Convert hh:mm:ss into mm:ss

[divianjani]

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

[Gysbert_Wassenaar]

Use the time() function: Time([opened time],'hh:mm:ss')

[its_anandrjs]

What is the format of the opened time field

You can try with

Time( [opened time],'hh:mm')

Regards

Anand