convert decimal into time

  • Thread starter Thread starter CENorth7272
  • Start date Start date
C

CENorth7272

I came up with a formula using ROUNDDOWN to convert a decimal time (ex:
1.25 hrs) so that the decimal will be read like you would read time
(ex: 1.25 hrs = 1.15). The formula is pretty long, especially if using
other functions or multiple cells for reference. So I have 2 questions:
1) Did I over-think this, is there an easier way, 2) Once I get the
time to read HR.MINS would there be a way to convert it to
HR:MINS...thanks Clay
 
Yes, assuming the decimal time is in A1, in B1 put =A1/24 and format it as
hh:mm, or [h]:mm if it is likely to be greater than 24 hours.
 
Assume you have 1.25 in A1 and you want to
convert it into Excel time 1:15

=A1/24

and format hh:mm

Regards,

Peo Sjoblom
 
Well I guess I did over-think it..MAJORLY. I haven't had to work much
with time functions and wasn't as familiar with them as I am with
others. This will be quite a time saver..thanks again, Clay
 
Back
Top