Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding times | Excel Discussion (Misc queries) | |||
reducing the number of times an IF statement needs to be calculated in embedded IF statements | Excel Discussion (Misc queries) | |||
Adding times | Excel Worksheet Functions | |||
Problem adding Series XValues to Chart using VBA | Charts and Charting in Excel | |||
problem with adding columns of numbers | Excel Worksheet Functions |