you'll probably want hh:mm:ss.
That may be all of it, actually. I tried my own set, and it worked fine.

"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!