Converting time

[Mark]

I have 325.42 minutes, if I subtract the actual time of day (start - 9:13
from finish of 14:38) i get 5 hrs and 25 minutes. If I use the convert
formula or divide by 60 i get 5 hrs and 42 min. How can i arrive at 5 hrs and
25 minutes

 

[Gary''s Student]

With your data in A1, enter:
=A1/24/60
and format as time to display: 5:25:25 AM

 

[Mike H]

Mark

With your munutes in a1 try this

=A1/1440

format as hh:mm

Mike

 

[David Biddulph]

Dividing by 60 or using =CONVERT(cell_ref,"mn","hr") you *don't* get 5 hrs
and 42 minutes, you get 5.42 (and a bit) hours. [Note 5.42 with a decimal
point, not 5:42 with a colon].
0.42 (and a bit) hours gives 25 (and a bit) minutes.

If you want to convert your decimal minutes to hours and minutes, use
=A2/(24*60) or =CONVERT(A2,"mn","day"), and in either case format as time,
with a time format to suit your preferences. Alternatively, use
=TEXT(A2/(24*60),"hh:mm") if you want the answer as text.