Formatting in time

G

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
Click to expand...
decimal hours ie 1.30 to read 1.5 hours
 
Top