Thread: Converting time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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