Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting total number of hours (24 hours) into days
I have a series of cells containing time spent. When I sum them up, it is 24
hours. When I format the cell with [h]:mm, I can see the total correctly. But I want to calculate number of days by dividing this hours by 8. How do I do it? -- MV Rao, VP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting total number of hours (24 hours) into days
To get a whole number as number of hours, multiply by 24
So for workdays, divide by 8 and multiply by 24 Times in Excel are stored as fractions of a day -- Kind regards, Niek Otten Microsoft MVP - Excel "MV Rao" wrote in message ... |I have a series of cells containing time spent. When I sum them up, it is 24 | hours. When I format the cell with [h]:mm, I can see the total correctly. But | I want to calculate number of days by dividing this hours by 8. How do I do | it? | -- | MV Rao, VP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Sum of hours as an equivalent in days and hours | Excel Discussion (Misc queries) | |||
Running total of hours based on last 7 days | Excel Worksheet Functions | |||
I need an Excel formula for converting hours to days? | Excel Worksheet Functions | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
converting hours to days,hours,minutes | Excel Worksheet Functions |