How do you subtract time? (ie 03:15 am minus 5 minutes)

D

Dennis

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.
 
M

Manish

Hi,
Use the article 214094 from support.microsoft.com
Also make sure that you have the cell formatting to Time 37:30:55

Manish
 
J

JE McGimpsey

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)
 
Top