Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Up Time Calcs
I am building a spreadsheet to add up hours worked per day and cumulative
hours worked per week. I can get the hours per day subtotal fine but get wierd numbers for the cummulative hours per week. All cells are formatted as hLmm and the Total for the Week cell has the formula of =SUM(B22:H22) but the anser I am getting comes no where near the actual sum of those cells. Can you solve this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Up Time Calcs
Your results are being truncated to a number less than 24 hours. To display
hour greater than 24 hours you need to use the time format under Custom Format that has a square bracket around the hours [h]. "ability" wrote: I am building a spreadsheet to add up hours worked per day and cumulative hours worked per week. I can get the hours per day subtotal fine but get wierd numbers for the cummulative hours per week. All cells are formatted as hLmm and the Total for the Week cell has the formula of =SUM(B22:H22) but the anser I am getting comes no where near the actual sum of those cells. Can you solve this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Up Time Calcs
In the total cell right click. Format Cells--Select Custom and enter [h]:mm
If this post helps click Yes --------------- Jacob Skaria "ability" wrote: I am building a spreadsheet to add up hours worked per day and cumulative hours worked per week. I can get the hours per day subtotal fine but get wierd numbers for the cummulative hours per week. All cells are formatted as hLmm and the Total for the Week cell has the formula of =SUM(B22:H22) but the anser I am getting comes no where near the actual sum of those cells. Can you solve this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I total a long list of time calcs? | Excel Worksheet Functions | |||
One more question pay calcs using [h]:mm format for time worke | Excel Discussion (Misc queries) | |||
Time calcs | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Time Calcs | Excel Worksheet Functions |