Issue with time formula

[dommy575]

Hi guys - im new to the forum so go easy on me haha

i have a set of data (below) and after a 24 hour period it adds it up into days (3rd , 6th and 8th line)

Does anyone know a formula i can use to convert these lines back into full hours / mins / secs? (eg - line 3 would be 38:39:27)

Any help would be most appreciated

Dom

Total Logged in Time

21:20:22

17:00:31

1.14:39:27

20:53:13

21:20:35

1.08:16:12

22:47:22

1.05:05:31

 

[KOKOSEK]

Book1
	A	B
1	Total Logged in Time	As time
2	21:20:22	21:20:22
3	17:00:31	17:00:31
4	1.14:39:27	38:39:27
5	20:53:13	20:53:13
6	21:20:35	21:20:35
7	1.08:16:12	32:16:12
8	22:47:22	22:47:22
9	1.05:05:31	29:05:31
Sheet1

Cell Formulas
Range	Formula
B2:B9	B2	=LET(t,TEXT(A2,"dd.hh:mm:ss"),newT,LEFT(t,FIND(".",t)-1),restT,MID(t,FIND(".",t)+1,LEN(t)-LEN(newT)),newT+restT)

Do not forget to format B column as Custom [hh]:mm:ss

 

[dommy575]

wow - that was quick and worked a treat

thank you so much for the help

 

[KOKOSEK]

Great to hear. Happy to help.