Time conversion
 

I want to set a formula in conditional formatting and convert all time
figures (hh:mm) in to normal numbering. Basically I want 12 hrs and 30
minutes to appear 12.50 Is this possible.
--
Peace in the world

Time conversion
 

=(MOD(G2,1))*24 formatted as 00.00

--
Don Guillett
SalesAid Software

"Seaman" wrote in message
...
I want to set a formula in conditional formatting and convert all time
figures (hh:mm) in to normal numbering. Basically I want 12 hrs and 30
minutes to appear 12.50 Is this possible.
--
Peace in the world