Change 60 minutes to 1 hour

  • Thread starter Thread starter nharris
  • Start date Start date
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?
 
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.
 
Back
Top