Complex sum of seconds

[yashsrawat]

Hi I need to help to sum below values in 00:00:00 format, but it not working.

If we add A+B+C=D, so it will give value in D col with 00:00:00 format

can some one help me,


A B c D
00:01:21 00:00:00 00:04:43 00:06:04
00:00:24 00:00:00 00:07:01
00:00:25 00:00:00 00:04:23
00:00:25 00:00:00 00:01:35
00:01:46 00:00:00 00:14:18

 

[Aladin Akyurek]

D2, copied down:

=SUM(A2:C2)

should do it. What is the problem you encounter?

 

[yashsrawat]

it not working, it shows me 00:00:00 only...

 

[Noodleski]

it not working, it shows me 00:00:00 only...

A difference in seconds is not time. The cell format is wrong.

 

[Aladin Akyurek]

it not working, it shows me 00:00:00 only...

Format D2 as:

[h]:mm:ss

and copy down.

 

[yashsrawat]

Nope it working

still showing 00

00:00:10 00:00:00 00:09:24 00:00:00
00:00:47 00:00:00 00:05:02 00:00:00
00:00:37 00:00:00 00:00:31 00:00:00
00:00:31 00:00:00 00:05:18 00:00:00
00:00:10 00:00:00 00:02:23 00:00:00
00:00:25 00:00:00 00:23:22 00:00:00

 

[tygrrboi]

Are you multiplying instead of adding?

 

[Aladin Akyurek]

Nope it working

still showing 00

00:00:10 00:00:00 00:09:24 00:00:00
00:00:47 00:00:00 00:05:02 00:00:00
00:00:37 00:00:00 00:00:31 00:00:00
00:00:31 00:00:00 00:05:18 00:00:00
00:00:10 00:00:00 00:02:23 00:00:00
00:00:25 00:00:00 00:23:22 00:00:00

E2:

=ISNUMBER(A2)

What result do you get in A2?

F2, formatted as general:

=A2*24*60*60

What do you get in F2?

 

[Noodleski]

What happens if you set it to number instead of anything time related.

 

[Aladin Akyurek]

Are you multiplying instead of adding?

He is instructed to run:

=SUM(A2:C2)