Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

divianjani
New Contributor II

Convert hh:mm:ss into mm:ss

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 MMSmiley FrustratedS format can anyone help me soon

2 Replies

Re: Convert hh:mm:ss into mm:ss

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


talk is cheap, supply exceeds demand

Re: Convert hh:mm:ss into mm:ss

What is the format of the opened time field

You can try with

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

Regards

Anand

Community Browser