Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hours converted to Days hours and minutes
Is there a function or a code I can create in Excel where
I can create hours into days with hours and minutes. For example I have 10.66 as hours..I want to change that in another cell to read 10 hours and whatever minutes .66 resepresents I think its like 37 minutes or so.. the same if I had lie 28.5 hours..want it to read 2 days 4 hours and 30 minutes. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convertin hours into days, hours and minutes | Excel Worksheet Functions | |||
converting days, hours and minutes to minutes | New Users to Excel | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
converting hours to days,hours,minutes | Excel Worksheet Functions |