Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do add time/hours to get answer in hours if Ans24
I am working out rosters over a three week period for 10 staff, I need to
calculate in time worked each day in hours & minutes (less meal breaks if applicable) and then add all the daily hours to get a weekly total in hours & minutes. The total hours are usually greater than 24. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do add time/hours to get answer in hours if Ans24
Format the cells as Time and pick the "13:30" option, which stands for
Hours:Minutes. Then in the column for the total switch to the "37:30:55" option. It will show your hours even above 24 and minutes, but you will have to ignore the last two digits which show seconds. If that's not good for you maybe someone else knows how to get just hours and minutes. None of Excel's hh:mm formats work above 24 hours. "Fran" wrote: I am working out rosters over a three week period for 10 staff, I need to calculate in time worked each day in hours & minutes (less meal breaks if applicable) and then add all the daily hours to get a weekly total in hours & minutes. The total hours are usually greater than 24. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do add time/hours to get answer in hours if Ans24
One way:
Format/Cells/Number/Custom [h]:mm In article , Fran wrote: I am working out rosters over a three week period for 10 staff, I need to calculate in time worked each day in hours & minutes (less meal breaks if applicable) and then add all the daily hours to get a weekly total in hours & minutes. The total hours are usually greater than 24. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
Can this adjusted GPA formual be accomplised? | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
calculate hours just can't figure it out | Excel Worksheet Functions | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |