ExcelBanter - How do I convert time (2:30) to a number (2.5) in a formula?

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

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

- - How do I convert time (2:30) to a number (2.5) in a formula? (https://www.excelbanter.com/excel-worksheet-functions/42353-how-do-i-convert-time-2-30-number-2-5-formula.html)

tammyj

How do I convert time (2:30) to a number (2.5) in a formula?

The difference in time between 12:00 am and 2:30 am is 2:30. How do I
convert that to a decimal (2.5) in the same formula?

Bob Phillips

=A1*24 and format as general.

--

HTH

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

"tammyj" wrote in message
...
The difference in time between 12:00 am and 2:30 am is 2:30. How do I
convert that to a decimal (2.5) in the same formula?

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