convert minutes into hours:minutes

G

Guest

I have 4 columns across the page that my staff needs to enter the number of
minutes they spend on a task. I then want to add the total number of minutes
and convert it to hours:minutes. What formula would I use to get the correct
formatting?

Example:

A1 = 25, B1 = 15, C1 = 45 Total minutes spent = 85 Desired Result is 1:25
(1 hour 25 minutes)
 
H

Harald Staff

There are 1440 minutes in 24 hours, so:
=(A1+B1+C1)/1440
format as time.

HTH. Best wishes Harald
 
B

Bob Phillips

=(A1+B1+C1)/1440

and make sure the target cell is formatted a time.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Removing minutes from hours:minutes in Excel 2
Body Shop Calculations 1
convert decimal numbers to a fraction of an hour for payroll hour 4
Converting a number to hours and minutes 4
Convert minutes into hours 3
Time Calculation 9
Convert minutes into hours and minutes 6
how can you convert hours into minutes? 2

Top