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

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.

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

Maybe

=TEXT(A1/1440,"H:MM")

where A1 contains the cell w/184 minutes.

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

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

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