Time change

S

scott45

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
 
R

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
Click to expand...

Assuming hour is in A1 try:

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

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top