change minutes to hours and minutes

G

Guest

Hello from Steved

I have a total off 1350 minutes and take away 30 minutes for the meal break.

What formula could I use please to get the result above. ( Hours and minutes )

Thankyou
 
B

Biff

Divide by 1440 and format as h:mm

=1350/1440 = 0.9375

Formatted as h:mm = 22:30

Biff
 

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

Convert Decimal hours and Minutes to minutes please. 13
Adding minutes. 2
Changing decimal numbers to hours and minutes 1
Hours and Minutes to minutes 5
Convert minutes into hours 3
Hours and sum of hours 2
sum hours and minutes with Excel 2000 9
coverting minutes to hours and minutes 1

Top