Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing up hours
How do I get the sum in hours and minutes for a range of fields that
are formatted as "time" (hh:mm)? I have two columns, one with starting time, one with ending time and a third column that calculates the difference between ending and starting time. I can sum up the third column, but only until it exceeds 24 hours. I understand that hours are handled like fraction of a day and I guess I have to convert that fraction into a number. At the same time I would have to keep the minutes as a fraction of an hour, because otherwise the summing up would be confused? TIA Örjan Skoglösa |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing hours and munites | Excel Discussion (Misc queries) | |||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
summing up hours spent on jobs | Excel Discussion (Misc queries) | |||
Summing hours | Excel Worksheet Functions | |||
Summing Hours and Minutes | Excel Discussion (Misc queries) |