| 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 |
| 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 | |||
Threaded Mode
