| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting work hours to day/hours/minutes
=INT(A1/9.5)&":"&TEXT(MOD(A1/9.5,1)*9.5/24,"hh:mm")
"WxmanPrice" wrote: I am trying to display various work hours/shifts as days:hours:minutes. For example 457.50 hours or 457:30 would be displayed as 61:00:00 or just 61 days (doesn't matter which is displayed whatever is easier) based on a 7.5 hour work day. I'd also like to have 2 additional columns. The next would be the above based on a 9.0 hour work day and the other based on a 9.5 hour work day. The 9.5 work day would be displayed as either 48:01:30 (all I can get it to show is 48:09). Any thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting hours, minutes, seconds, to hours | Excel Worksheet Functions | |||
| Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
| converting hours to hours & minutes | Excel Discussion (Misc queries) | |||
| Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
| converting hours to days,hours,minutes | Excel Worksheet Functions | |||
Threaded Mode
