In Excel how can you convert a cell formatted for time (4:30) to .

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.

=H1*24 and format as general.

--

HTH

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


"Lisa" <Lisa@discussions.microsoft.com> wrote in message
news:AED5E0B7-CF57-4466-8735-4C7D5354A145@microsoft.com...
> 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.