Thread: Converting time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Converting time

Mark

With your munutes in a1 try this

=A1/1440

format as hh:mm

Mike

"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