Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
I think I'd convert that cells with the 184 minutes into a real time with
something like: =A1/60/24 And then format that the way you like. tpendy wrote: I have two data sets to combine. They have cells containing elapsed time. One format has total minutes (184). The second has [h]:mm (3:04). As I have used the [h]:mm format in a number of related jobs I would prefer to convert to that format. -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I convert a number of minutes into hours and minutes? | Excel Worksheet Functions | |||
Convert a number of minutes like 400 into hours and minutes | Excel Worksheet Functions | |||
convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
convert minutes into hours:minutes | Excel Worksheet Functions |