Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you subtract time? (ie 03:15 am minus 5 minutes)
I am setting up a spreadsheet to figure on start time from the end time to
start time. I need to subtract time from the previous cell to the next cell. |
#2
|
|||
|
|||
Hi,
Use the article 214094 from support.microsoft.com Also make sure that you have the cell formatting to Time 37:30:55 Manish "Dennis" wrote: I am setting up a spreadsheet to figure on start time from the end time to start time. I need to subtract time from the previous cell to the next cell. |
#3
|
|||
|
|||
One way:
XL stores times as fractional days, so all you need to do is subtract, and format the resulting cell as a time: A1: <start time B1: <end time C1: =B1-A1 Since times "roll over" at midnight, if your times span midnight, you need to add 1 (for 1 day) to the "later" time. You can use XL's implicit coercion of TRUE/FALSE to 1/0: C1: =B1-A1 + (B1<A1) or the more obscure, but equivalent C1: =MOD(B1-A1,1) In article , Dennis wrote: I am setting up a spreadsheet to figure on start time from the end time to start time. I need to subtract time from the previous cell to the next cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtract one time from another and get answer in minutes | Excel Discussion (Misc queries) | |||
What formula is used to add or subtract minutes from a time in a . | Excel Worksheet Functions | |||
how can i subtract time from two different date? | Excel Worksheet Functions | |||
Subtract Decimal time | Excel Worksheet Functions | |||
how do you subtract military time? example 12:00 - 07:00 = 5 hour. | Excel Worksheet Functions |