How do I convert 184 minutes into 3:04 (3 hours:4 minutes) in EXCE

T

tpendy

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.
 
D

Dave Peterson

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.


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.
Click to expand...
 
Top