topic convert to seconds in QlikView

convert to seconds

Thu, 23 Oct 2014 10:00:19 GMT

hi guys, i want to convert 12:15:44 to seconds how can i do that

thanx.

alexandros17 — Thu, 23 Oct 2014 10:08:09 GMT

hour('12:15:44')*3600+minute('12:15:44')*60+second('12:15:44')

let me know

MK_QSL — Thu, 23 Oct 2014 10:11:58 GMT

=Time('12:15:44')*24*60*60

Thu, 23 Oct 2014 10:15:16 GMT

Num('12:15:44') * 86400

This converts your time field to a number which represents the fraction of a day (0.51092592592593)

Then multiply by 86400 because there are 86400 seconds in a day

its_anandrjs — Thu, 23 Oct 2014 10:20:04 GMT

Try this also in any text object

=Second( Time('12:15:44')) +

Minute( Time('12:15:44')) * 60 +

Hour( Time('12:15:44')) * 60 * 60

Thu, 23 Oct 2014 10:27:12 GMT

Thank you guys, all the solutions that you have suggested are correcte.

alexandros17 — Thu, 23 Oct 2014 10:29:14 GMT

... could you please give marks??

Thu, 23 Oct 2014 10:31:32 GMT

Try Interval('12:15:44','s')) for a more simplistic solution keep in mind that you need the date to have the right format.