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)) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Express Hours in Days Q
Just figured it out, I think
=(((((((60*8)/1440)-I14))*I6))/(60*8))*1440 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Express Hours in Days Q
You didn't tell us what is in I6 or I14 when you got your 190 hrs 46 min
answer nor how the cell is formatted, but if your answer is really in hours (I'm assuming the Formula Bar is showing 190.766666666666667), why not simply divide it by 8 (perhaps rounding up depending on what you want to do with fractional day amounts that result from the division) to get how many 8-hour days that is equivalent to? -- Rick (MVP - Excel) "Seanie" wrote in message ... 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)) |
Reply |
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 |