Problem with adding calculated times
Use custom format in the cell with the totals like [hh]:mm
Regards,
Peo Sjoblom
Mollyb wrote:
I've been handed a blank spreadsheet for the employees to enter time arrived
at work and time departed. I needed to compute the total time Monday-Friday
worked, so I've used the formula =[departure]-[arrive]-TIME(0,60,0) to
compute the work time minus lunch hour each day. The arrive/departure
columns are formatted as general and time is entered as 7:30, 13:30, etc.
The total column is formatted as custom h:mm:ss. I can get any two days to
add up correctly, but when I enter the third day the total reverts to
0:00:00. I'm obviously not doing something correctly. Can you help?
Thanks!
|