scriptscribe
MIS
I have a group of data that I need to convert to hours minutes and seconds (with leading zeros) that looks like this.
124802
12458
2365
785
96
6
I've written the following code:
This separates out the first two into
12:48:02
01:24:58
When I try to add a third nested if statement to convert the third and following cells into this time type I keep getting kicked back an error.
Any help would be greatly appreciated.
Mike
124802
12458
2365
785
96
6
I've written the following code:
Code:
=IF(A1>99999,(CONCATENATE(LEFT(A1,2),":",MID(A1,3,2),":",RIGHT(A1,2))),IF(A1>9999,(CONCATENATE("0",LEFT(A1,1),":",MID(A1,2,2),":",RIGHT(A1,2)))))
This separates out the first two into
12:48:02
01:24:58
When I try to add a third nested if statement to convert the third and following cells into this time type I keep getting kicked back an error.
Any help would be greatly appreciated.
Mike