=H1*24 and format as general.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lisa" wrote in message
...
I've compiled an excel sheet for tracking my working hours to calculate at
the end of the week my pay due. The final column displays the total work
hours as 20:30 (20 Hrs 30 Mins). I would like to know how I can convert
this
to read 20.5 Hrs.