subtracting time

  • Thread starter Thread starter aggierian
  • Start date Start date
A

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.
 
aggierian said:
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.
Click to expand...
Try

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

Geoff
 
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.
 
Back
Top