View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR
 
Posts: n/a
Default convert number to time

I would like to ask for help.

I have to convert a number 5.27 to time 5:16 as minutes and seconds. I am
using the following to convert: =perform_dump!B35/24/60, however the return
is showing an AM/PM and I just need minutes and seconds to I can run
variances.

Any solutions?

Thanks