Changing decimal numbers to hours and minutes

J

Joyce O

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hours and sum of hours 2
Displaying hours and minutes 3
Time Calculated minus breaks & lunch 2
would like to know how to convert 2 hours and 30 minutes into 2.5 5
Date/time difference 3
sum hours and minutes with Excel 2000 9
Figuring and adding time in Excel 2
Converting hour/minutes to hours/hundredths 1

Top