HOURS TO NUMBER CONVERSION
Posted by Wilfred on February 08, 2002 10:21 AM
Is there a way I can generate a numeric field from an hour field?
e.g: convert 7:30 to 7.3
Thanks
Posted by Juan Pablo G. on February 08, 2002 11:09 AM
Shouldn't this be 7:30 = 7.5 ?
If so, put this
=A1*24
and format this cell as general.
Juan Pablo G.
