MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.