subtracting time

[aggierian]

I am making a spreadsheet that tracks my hours at work. I want to enter
my start and end time and find out how many hours worked. The problem
I run into is that if I start before midnight, and get out after
midnight and try to subtract (Ex: 1a minus 6p) excel won't return the
value, it says it won't display a negative time.

 

[GB]

I am making a spreadsheet that tracks my hours at work. I want to enter
my start and end time and find out how many hours worked. The problem
I run into is that if I start before midnight, and get out after
midnight and try to subtract (Ex: 1a minus 6p) excel won't return the
value, it says it won't display a negative time.

Try

If(T2>T1,T2-T1,1+T1-T2)

Geoff

 

[Peo Sjoblom]

Or shorter but less comprehensible

=MOD(End-Start,1)

 

[theroo]

Excel is very smart. If you enter your values as date-time excel automatically handles the cross over midnight. Enter your values this way 11/8/02 23:25. The trick is date SPACE time. You can choose whatever date/time format you want but enter both in the same cell separated by a space. Amazing ain't it. Nurses have to know these things.