how to add minutes to give hours using excel e.g. 30m +30m = 1hr

[Guest]

When I use excel to get a sum of cells. e.g add 30 + 30 +30 minutes will
give me 90 instead of 1 hour 30 minutes. How do I set the cells to give me
the correct sum total?

 

[Bob Phillips]

=SUM(A1:A3)/24/60

and format as time

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Trevor Shuttleworth]

If you enter the times as hh:mm:ss, for example, in this case, as 00:30:00,
then, when you add them up, Excel will automatically show the sum as
01:30:00. If the total will exceed 24 hours, format the cell as [hh]:mm:ss

Alternatively, you can divide 90 by 24*60 (1440) and format as [hh]:mm:ss

That is, for example:

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

Regards

Trevor