Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all ,
I have a field like "opened time" -> it's showing like this "'1.22:43:8.000'' s but my requirement need to display into MM:SS format can anyone help me soon
Use the time() function: Time([opened time],'hh:mm:ss')
What is the format of the opened time field
You can try with
Time( [opened time],'hh:mm')
Regards
Anand