If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Convert hours into days hours 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
|
|||
|
|||
Hi Alex
Excel stores dates and times as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day: ddddd.tttttt .. This is called a serial date-time. http://www.cpearson.com/excel/datetime.htm So simply convert your hours cells into fractions of a day. If 10.66 is in A1 (the hours-cell), then in B1 (the days-cell) put the formula =A1/24. Then format the days-cell with the custom format "dd:hh:mm". It will then display it the way you want. 0.66 (2/3) of an hour = 40 mins. Excel will probably display this as 39 mins as 0.66 is not quite 2/3. To 4-decimal places, 0.6666, will take it up to 40. Regards Paul "Alex" wrote in 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Convert digital time to hours and minutes | Ian | General Discussion | 2 | August 13th, 2004 08:27 AM |
too complex for me! | RandyH | Setting Up & Running Reports | 8 | July 2nd, 2004 05:37 PM |
log book | Joe | New Users | 2 | June 23rd, 2004 04:39 PM |
Converting to Days and percentage of 24 Hours. | Frank Kabel | Worksheet Functions | 2 | April 1st, 2004 12:08 AM |
Convert 13 hours a 10 minutes to total minutes | John | Worksheet Functions | 2 | September 29th, 2003 04:07 PM |