Time Subtraction...

  • Thread starter Thread starter George Czarnonycz
  • Start date Start date
G

George Czarnonycz

Hello all...

I been trying this for hours....

Is there a way to subtract / add TIME on a timesheet?
I have an excel document that the user puts in time in and time out (format
hh:mm)..
Then they have to go to the ttl hours field and do the subtraction/addition
themselves...

Is there a way to do this?

Thanx!2
cZ
 
Yes, use =1time+2time or =sum(1time,2time) or =sum(timerange) for adding
and use minus for subtracting =end_time-start_time
 
Forgive my ignorance... do you have to name the cell in order for this to
work?
I have formatted the cells for "hh:mm" then in the Total field I do a simple
+ or -
It looks fine but then I try to do a Sum to give the weekly total and I cann
ot get it to display the right hours...

What do you think I'm doing wrong?
 
try formatting the total cell as "[h]:mm" (or "[hh]:mm")

This will show the total hours--no wrapping to days.
 
Back
Top