Convert Number to Hours/Minutes

  • Thread starter Thread starter CindyA
  • Start date Start date
C

CindyA

I would like to convert a whole number (for instance, 2.4)
to read 2 hours 24 minutes. Each .1 would be equal to 6
minutes. I tried looking at the =CONVERT formula and have
had no luck. Changing the format will not work either.
Any ideas? Thanks in advance.
 
Cindy,

Glad to hear it, but unfortunately our holiday weekend was last weekend, so
not for us in the UK (sigh!).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting hour/minutes to hours/hundredths 1
Convert minutes into hours 3
Convert text entered as minutes/seconds to minutes 1
Converting a number to hours and minutes 4
Converting time to decimal format 17
Convert minutes into hours and minutes 6
coverting minutes to hours and minutes 1
Converting a decimal time into hours and minutes 1

Back
Top