Converting time
With your data in A1, enter:
=A1/24/60
and format as time to display: 5:25:25 AM
--
Gary''s Student - gsnu200810
"Mark" wrote:
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
|