ExcelBanter - Converting hour/minutes to hours/hundredths

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

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

- - Converting hour/minutes to hours/hundredths (https://www.excelbanter.com/excel-worksheet-functions/252392-converting-hour-minutes-hours-hundredths.html)

Tbazemore

Converting hour/minutes to hours/hundredths

I have an excel spreadsheet which has hours/minutes and I need to convert it
to hours/hundredths (example 2:13 to 2.22). Is there a formula to complete
this conversion?

Thank You.

Luke M

Converting hour/minutes to hours/hundredths

=A2*24
Format cell to 2 decimal places.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Tbazemore" wrote:

I have an excel spreadsheet which has hours/minutes and I need to convert it
to hours/hundredths (example 2:13 to 2.22). Is there a formula to complete
this conversion?

Thank You.

All times are GMT +1. The time now is 09:55 AM.