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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - In Excel how can you convert a cell formatted for time (4:30) to . (https://www.excelbanter.com/excel-worksheet-functions/13157-excel-how-can-you-convert-cell-formatted-time-4-30-a.html)

Lisa

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.

Bob Phillips

=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.

All times are GMT +1. The time now is 11:03 AM.