ExcelBanter - Changing decimal numbers to hours and minutes

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

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

- - Changing decimal numbers to hours and minutes (https://www.excelbanter.com/excel-worksheet-functions/246184-changing-decimal-numbers-hours-minutes.html)

Joyce O

Changing decimal numbers to hours and minutes

I have a report that reads 2.5 for 2 hours and 30 minutes. How do I get it
to show in hours and minutes?

Pete_UK

Changing decimal numbers to hours and minutes

Assuming you have 2.5 in A1, use this formula in another cell:

=A1/24

and format that cell as [h]:mm.

Hope this helps.

Pete

On Oct 21, 11:50*pm, Joyce O <Joyce
wrote:
I have a report that reads 2.5 for 2 hours and 30 minutes. *How do I get it
to show in hours and minutes?

All times are GMT +1. The time now is 03:10 PM.