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?

=SUM(A1:A3)/24/60

and format as time

--

HTH

Bob Phillips

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

"alphonia" <(E-Mail Removed)> wrote in message
news:AF7527F9-F359-4503-9006-(E-Mail Removed)...
> 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?

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


"alphonia" <(E-Mail Removed)> wrote in message
news:AF7527F9-F359-4503-9006-(E-Mail Removed)...
> 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?