• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Time Convesion

[Solved] Time Convesion

Dear All,

anyone knows business function to quickly convert time.

The example is like:

My table has TDAY with content:
9 means "00:00:09"
30 means "00:00:30"
123 means "00:01:23"
3350 means "00:33:50"
93429 means "09:34:29"
235500 means "23:55:00"

If possible, i don't want to use the "if - lenght - substr - concat" way, it's too long.

So anyone knows a business function to do that? OR any short way to do that.

Thank you very much


=============================edit by Me 07/11/19

I user B9800188

bf.jpg

Thanks all
 
Last edited:
Top