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

 

[MarcelBeug]

Then your cells are not formatted as time.

Either format your cells as time, or in D2: =SUMPRODUCT(A2:C2*1)
Format D2 as suggested by Aladin.

 

[yashsrawat]

E2:

=ISNUMBER(A2)

Result is False

What result do you get in A2?

F2, formatted as general:

=A2*24*60*60

Result is 1944:00:00

What do you get in F2?

Result is False

Result is 1944:00:00

 

[yashsrawat]

thanks Marcel... it works... and thanks all for your help..specally Aladin

 

[Aladin Akyurek]

Result is False

Result is 1944:00:00

thanks Marcel... it works... and thanks all for your help..specally Aladin

In order to change the undelying format, try to copy an untouched cell, select the input range, run Paste Special >> Add.

 

[yashsrawat]

thanks Aladin