J Joyce O Oct 21, 2009 #1 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?
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?
P Pete_UK Oct 21, 2009 #2 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
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
