Converting time
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.
--
David Biddulph
"Mark" wrote in message
...
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
|