Converting Time from HH:MM to HH:MM:SS using a Formula

[Jambi46n2]

Hello,
I was given a workbook with various sheets of data regarding timestamps. I need to total these in HH:MM:SS
The problem is in the first column Time was formatted in HH:MM, when it should look like the results entered manually on the right.
When I update the formatting from the home ribbon to convert to HH:MM:SS the results are incorrect.
Is there a formula that could perhaps populate the correct values on the right column?
Thanks much in advance!

Time in HH:MM	Time Should Be HH:MM:SS
0:01​	0:00:01​
0:14​	0:00:14​
0:24​	0:00:24​
0:02​	0:00:02​
0:30​	0:00:30​

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1	Time in HH:MM	Time Should Be HH:MM:SS
2	00:01	00:00:01	00:00:01
3	00:14	00:00:14	00:00:14
4	00:24	00:00:24	00:00:24
5	00:02	00:00:02	00:00:02
6	00:30	00:00:30	00:00:30
Sheet4

Cell Formulas
Range	Formula
C2:C6	C2	=A2/60

 

[Jambi46n2]

How about

Fluff.xlsm
	A	B	C
1	Time in HH:MM	Time Should Be HH:MM:SS
2	00:01	00:00:01	00:00:01
3	00:14	00:00:14	00:00:14
4	00:24	00:00:24	00:00:24
5	00:02	00:00:02	00:00:02
6	00:30	00:00:30	00:00:30
Sheet4

Cell Formulas
Range	Formula
C2:C6	C2	=A2/60

I feel like a dummy that it was really that simple. Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.