I export a file that contains time, but when the time is < 1 hour, it does not export with a preceding zero so the format is not in time. I need a formula in a helper column that says something like, if cell starts with : then add 0?
:56:55 (does not export in time)
1:19:19 (does export in time)
Bookmarks