Time change

[Guest]

In my spreedsheet I figure plant hours but the problem I have say my hours
are 7:30 hours. For other calculations I need 7 1/2 hours to read as 7.5. Is
there a way to change 7:30 into 7.5 hours

thanks in advance
Scott

 

[Bob Phillips]

Multiply by 24, as time is stored as a fraction on a day.

 

[Richard Buttrey]

In my spreedsheet I figure plant hours but the problem I have say my hours
are 7:30 hours. For other calculations I need 7 1/2 hours to read as 7.5. Is
there a way to change 7:30 into 7.5 hours

thanks in advance
Scott

Assuming hour is in A1 try:

=HOUR(A1)+MINUTE(A1)/60

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________