Change 60 minutes to 1 hour

N

nharris

I have a worksheet with a several fields that I place in minutes on
projects.
I need to total up the mintues to relect hours.
For example:
A1 , I have 54 minutes
A2 , I have 6 minutes
A3 , I have =SUM(A1:A2)

How do I get A3 to show total of 1 hour?
 
J

JE McGimpsey

One way:

=SUM(A1:A2)/60


If you want the result as an XL time:

=SUM(A1:A2)/(60*24)

or, equivalently

=SUM(A1:A2)/1440

format as time.
 

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

Calculate end date and time 1
Format for Time Elapsed in Decimal 4
Total Hours 7
Changing from hours to minutes. 2
Avoiding redundant calculations 7
Displaying the Remind Beforehand Value in Calendar List View 0
Converting Seconds to Hours, Minutes, Seconds 3
sum only if there is a value in cells 2

Top