View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joaniemic joaniemic is offline
external usenet poster
 
Posts: 14
Default convert time in decimals to minutes

I'm trying to

(a) convert time shown in decimals to time in minutes. Example, I would like
3.75 to become 4:15 (4 minutes 15 seconds).

(b) I then take an average of 5 or six of the above numbers.

Thank you.