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

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

--
HTH

Bob Phillips

"scott45" wrote in message
...
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

On Mon, 19 Sep 2005 05:42:03 -0700, "scott45"
wrote:

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
__________________________