I have the field below, which is a time interval. I need to add ":" between the hours and the minutes:
So for example:
0000 --> 00:00
0010 --> 00:10
What is the formula that can do this?
Thank you so much,
Try this : Left([Time Interval],2)+":"+RIGHT([Time Interval],2)
Find my approach,
you can use DATEPARSE("hhmm",[Your String]) it will convert into datetime then change the default date format of your field as per the screenshot.
Let us know if this help.
Retrieving data ...