Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Convert a number of minutes like 400 into hours and minutes
How would i convert 2000 minutes into hours and minutes? I dont know why i cant work this out. Thanks! -- bloke ------------------------------------------------------------------------ bloke's Profile: http://www.excelforum.com/member.php...o&userid=24611 View this thread: http://www.excelforum.com/showthread...hreadid=381961 |
#2
|
|||
|
|||
First, format the output cell as Custom [H]:mm then enter this formula: =(A1/1440) where A1 holds your 2000 minutes. This will return 33:20 (which is 2000/60 to get a decimal hours and then /24 to get a decimal days. Formatting as above (bracketed 'H') forces Excel to return total hours and not round it to days. HTH -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=381961 |
#3
|
|||
|
|||
That is great, thank you very much indeed. -- bloke ------------------------------------------------------------------------ bloke's Profile: http://www.excelforum.com/member.php...o&userid=24611 View this thread: http://www.excelforum.com/showthread...hreadid=381961 |
#4
|
|||
|
|||
You are most welcome. Glad it worked for you. Feedback is always appreciated. Cheers! -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=381961 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes.. | Excel Discussion (Misc queries) | |||
"Convert to Number" option disappearing | Excel Discussion (Misc queries) | |||
Tracking Hours and Minutes | Excel Discussion (Misc queries) | |||
how can I add cells in hours and minutes, eg 1.15 +1.45 to equal . | Excel Worksheet Functions | |||
How can I convert fractional hours to minutes? | Excel Discussion (Misc queries) |