| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I convert minutes to hours:minutes?
I am building a spreadsheet that tracks the minutes to complete specific
tasks. I have not been able to find a formula(s) that will convert the minutes into hrs:min notation. Thank you. |
|
#2
|
|||
|
|||
|
XL stores times as fractional days, so if you have your minutes value in
A1, divide by 24*60: B1: =A1/1440 and format B1 as hh:mm In article , Marc Todd <Marc wrote: I am building a spreadsheet that tracks the minutes to complete specific tasks. I have not been able to find a formula(s) that will convert the minutes into hrs:min notation. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Adding minutes to time | Excel Discussion (Misc queries) | |||
| How do I convert times from hours to minutes? | Excel Discussion (Misc queries) | |||
| how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
| Minutes to seconds - how to convert? | Excel Worksheet Functions | |||
Linear Mode
