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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hours converted to Days hours and minutes
Am I correct that you are not using the Excel date/time
values (where 1.0 would equal one day) but instead a decimal number for the hours value? If that is true, then this formula will convert the number into days/hours/minutes (assuming your hours value is in cell A1): =INT(A1/24)&" days "&INT(MOD(A1,24))&" hours "&ROUND(MOD (A1,1)*60,0)&" minutes" -----Original Message----- 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 . |
Reply |
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 |