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
|
|||
|
|||
to convert Minutes into Day:Hr:min (not as fraction)
Hi to all
The really simple things are the hardest! I have a figure which is in minutes say 10856, and I which to convert it into days:hrs:min. ie 7 days 12 hrs and 55 mins and 8 sec. each attempt at the formula has given me fractions of hours, mins etc which I have to convert back to whole minutes. Is there a simple way?? any help will be greatly appreicated. Thanks in advance Noel |
#2
|
|||
|
|||
On Mon, 5 Sep 2005 18:34:05 -0700, "NoelH"
wrote: Hi to all The really simple things are the hardest! I have a figure which is in minutes say 10856, and I which to convert it into days:hrs:min. ie 7 days 12 hrs and 55 mins and 8 sec. each attempt at the formula has given me fractions of hours, mins etc which I have to convert back to whole minutes. Is there a simple way?? any help will be greatly appreicated. Thanks in advance Noel Excel stores time as fractions of a day. There are 1440 minutes in a day. So with your time in A1: =A1/1440 Format as d:hh:mm := 7:12:56 Or, if you want the text: Format as d\d h\h m\m 7d 12h 56m In your example, you give a "seconds" parameter. I don't see how you get that if your data is in minutes. --ron |
#3
|
|||
|
|||
Divide by 1440 and use a custom format like d "days" hh:mm:ss
Don't know where you get seconds from 10856 minutes? -- Regards, Peo Sjoblom (No private emails please) "NoelH" wrote in message ... Hi to all The really simple things are the hardest! I have a figure which is in minutes say 10856, and I which to convert it into days:hrs:min. ie 7 days 12 hrs and 55 mins and 8 sec. each attempt at the formula has given me fractions of hours, mins etc which I have to convert back to whole minutes. Is there a simple way?? any help will be greatly appreicated. Thanks in advance Noel |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do I convert minutes to decimals? | KaitlinAngelBrat | General Discussion | 2 | September 21st, 2005 11:05 PM |
Convert a number of minutes like 400 into hours and minutes | bloke | Worksheet Functions | 3 | June 24th, 2005 05:00 PM |
Convert digital time to hours and minutes | Ian | General Discussion | 2 | August 13th, 2004 08:27 AM |
Converting minutes to hours and minutes | wendy | Worksheet Functions | 1 | October 14th, 2003 03:17 PM |
Convert 13 hours a 10 minutes to total minutes | John | Worksheet Functions | 2 | September 29th, 2003 04:07 PM |