Sum time

[Maria Soto]

I need sum cells with time. How to do it?
Thank you

 

[Dave Peterson]

Just add them up (=a1+a2 or =sum(a1:a3))

You may want to format the cells as: [hh]:mm:ss

to show 36:20:00

(use the h/m/s codes for your location.)

 

[Maria Soto]

The case is:
A1=15:17 and A2=23:04
When I sum A1+A2 the result is incorrect:
=Sum(A1:A2) = 14:21 Why????
Thank you.

-----Original Message-----
Just add them up (=a1+a2 or =sum(a1:a3))

You may want to format the cells as: [hh]:mm:ss

to show 36:20:00

(use the h/m/s codes for your location.)

I need sum cells with time. How to do it?
Thank you

--

Dave Peterson
(e-mail address removed)
.

 

[Dave Peterson]

It's 1 day, 14 hours (38 hours) and 21 minutes.

Try that custom format [hh]:mm:ss

the square brackets tell excel to not wraparound to days--just keep it hours.

The case is:
A1=15:17 and A2=23:04
When I sum A1+A2 the result is incorrect:
=Sum(A1:A2) = 14:21 Why????
Thank you.

-----Original Message-----
Just add them up (=a1+a2 or =sum(a1:a3))

You may want to format the cells as: [hh]:mm:ss

to show 36:20:00

(use the h/m/s codes for your location.)

I need sum cells with time. How to do it?
Thank you

--

Dave Peterson
(e-mail address removed)
.