Thread: Changing decimal numbers to hours and minutes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default 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?

Reply With QuoteReply With Quote