Formatting in time

[Guest]

This formula will work:
With time in cell "A1"


=INT(A1)+((A1-INT(A1))/0.6)

Good Luck

Mike

-----Original Message-----
I have a column of figures of hours and minutes - displaying -

1.30 (1 hour 30 mins)
0.45 (45 mins)
1.15 (1 hour 15 mins etc, etc)

Can anyone tell me how to format (or otherwise) to show

decimal hours ie 1.30 to read 1.5 hours

 

[Guest]

Brill - thanks Mike - it works a treat!