| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Express Hours in Days Q
My formula below returns a value of 190 hrs 46 min, however what I am
trying to do is express this in days, if each day = 8 hrs, I'm expecting approx 24 days to be returned. How can I do this? I've tried formatting, dividing by 8 etc but cannot work it out =((((((60*8)/1440)-I14))*I6)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting total number of hours (24 hours) into days | Excel Discussion (Misc queries) | |||
| Display Sum of hours as an equivalent in days and hours | Excel Discussion (Misc queries) | |||
| Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
| Convert decimal days to Days,hours, minutes | Excel Worksheet Functions | |||
| Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
Threaded Mode
