Hi

I am wondering if anyone have a formula to convert times ie:

1214 to 12:14:00

Would be really greatful if some could help as I really need this and Im completly goosed