Atsiprašome, tačiau šis straipsnis neprieinamas jūsų kalba.
Laiko pridėjimas arba atėmimas

Laiko atėmimas

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

You can subtract time in Excel almost like you subtract other types of numbers. To do this, you use a formula; there isn’t any auto-subtract button. Like with adding time, you can also subtract a unit of time, such as 1½ hours, from a time of day, such as 10:00 a.m., by using the TIME function.

Subtract time

You know your start and end times at a volunteer project, and want to know the elapsed time.

  1. In cell B2, type the start time, enter a space, and then type “a” for AM or “p” for PM, and press Enter.

  2. In cell C2, type the end time, including “a” or “p” as appropriate, and press Enter.

  3. Type the other start and end times for your friends Joy and Leslie.

  4. In cell D2, subtract the end time from the start time by typing the formula: =C2-B2, and then pressing Enter.
    We need to format cell D2 to get rid of “AM.”

  5. Then on the HOME tab, click Format > Format Cells.

  6. In the Format Cells box, click Custom in the Category list.

  7. In the Type list, click h:mm (for hours and minutes), and then click OK. Now, we see that Richard worked 3 hours and 45 minutes.

  8. To get the results for Joy and Leslie, copy the formula by clicking in cell D2 and dragging to cell D4. The formatting in cell D2 is copied along with the formula.

Want more?

Add or subtract time

Create or delete a custom number format

TIME function

Tobulinkite savo „Office“ įgūdžius
Ieškoti mokymo
Pirmiausia gaukite naujų funkcijų
Prisijunkite prie „Office Insider“ dalyvių

Ar ši informacija buvo naudinga?

Dėkojame už jūsų atsiliepimus!

Dėkojame už jūsų atsiliepimą! Panašu, kad gali būti naudinga jus sujungti su vienu iš mūsų „Office“ palaikymo agentų.