Problem with adding calculated times
 

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!

Problem with adding calculated times
 

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!

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!

Problem with adding calculated times
 

Thank you both. The logic of a single digit versus double just truly escaped
me. I guess I can blame it on frustration rather than the "duh" factor!

"Peo Sjoblom" wrote:

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!