Sum formula required to total hh:mm:ss

[WendyHubard]

Hello,
I have multiple spreadsheets and I'm trying to total columns that contain time duration in the format of hh:mm:ss (sample below). Have the column format set to hh:mm:ss but it's just not working. Have also tried "text to columns" and removed all delimiters.
Any help greatly appreciated. Thanks in advance

	09:53:00​
	05:59:00​
	10:00:00​
	10:00:00​
	10:00:00​
	05:50:00​
	09:58:00​
	00:05:00​
	06:21:00​
total using Sum	20:06:00​

 

[Herakles]

Thank you!!!!! That seems to do the trick Thank you all for your help.

Do you want to change the raw data to minutes and seconds to avoid problems in the future?

 

[Dave Patton]

Thanks for the feedback.
N.B.

Dates Time.xlsm
	F	G	H
1			General format
2	00:09:53	00:09:53	0.006863
3	00:05:59	00:05:59	0.004155
4	06:00	06:00:00	0.25
4aa

Cell Formulas
Range	Formula
G2	G2	=TIME(0,9,53)
H2:H4	H2	=F2
G3	G3	=TIME(0,5,59)
G4	G4	=TIME(6,0,0)

Dave

 

[WendyHubard]

Fabulous!!! I'll copy the formula. Have lots and lots of files to review. Really appreciate your help