topic Time Formmating in QlikView

Time Formmating

Wed, 25 Nov 2020 16:16:04 GMT

Hi Community

Can you ugently assist me .i have a create date field which shows something like this " 23445 " bu i want it to show "06:08:00 am/pm"

See the attached .

Regards

Mutshidzi

sunny_talwar — Tue, 15 Mar 2016 08:51:21 GMT

Is this in seconds? If it is, then may be this:

=Time(TimeField/(60*60*24))

Chanty4u — Tue, 15 Mar 2016 08:54:09 GMT

Try Date(Field,’hh:mm:ss’)

interval(timefield ,'hh:mm:ss')

its_anandrjs — Tue, 15 Mar 2016 08:54:18 GMT

Try this

=Time(23445,'hh:mm:ss TT')

Regards

Anand

Chanty4u — Tue, 15 Mar 2016 08:57:25 GMT

try

Date(Field,’hh:mm:ss TT’)

interval(timefield ,'hh:mm:ss TT')

=Interval(Timestamp#('urfield','time format'),'hh:mm:ss TT')

Tue, 15 Mar 2016 09:26:13 GMT

Hi Guys

let me give a good example of my issue ,

253 suppose to show 00:02:53

20904 suppose to show 01:09:04

Thanks

Chanty4u — Tue, 15 Mar 2016 10:19:53 GMT

might be

=Time(Interval#(Time, 'hh:mm:ss'))

Time(maketime( Left(A1,2), RIGHT(A1,2)), 'hh:mm:ss') as Time

Chanty4u — Tue, 15 Mar 2016 10:23:11 GMT

Have a look at the HELP, search for 'format codes' and 'date and time functions'.

Kushal_Chawda — Tue, 15 Mar 2016 10:24:16 GMT

try this,

Time(Time#(num(TimeField,'000000'),'hhmmss'),'hh:mm:ss TT')