M
Maria Soto
I need sum cells with time. How to do it?
Thank you
Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.)
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.)
M
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.
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.)
Maria said:I need sum cells with time. How to do it?
Thank you
--
Dave Peterson
(e-mail address removed)
.
D
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.
Try that custom format [hh]:mm:ss
the square brackets tell excel to not wraparound to days--just keep it hours.
Maria said: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.)
Maria said:I need sum cells with time. How to do it?
Thank you
--
Dave Peterson
(e-mail address removed)
.