topic Time Syntax in QlikView

Time Syntax

Dayna — Fri, 14 Jan 2011 10:42:01 GMT

Hello All,

I hope you can advise as to an expression i'm trying to do.. I have an application where we log time, i.e. 15 minutes to complete a task. In the database, 15 minutes is represented as 900000, one minute is represented as 60000.. It will never be lower than one minute.

Could you advise as to an expression that would convert this to show how many minutes/hours/days has been assigned. I.e. 01:10:15 would be 1 day, 10 hours n fifteen minutes.

Your help would be most appreciated!!!

Kind Regards,
Dayna

Time Syntax

Fri, 14 Jan 2011 11:21:21 GMT

in qlikview, time is stored as numbers of days since 12/30/1899.

you are storing time as milliseconds, so you have to convert it into a number of days and format the value as a time interval: there are 24 * 60 * 60 * 1000 millisecons in a day, so the number of days is:

NumberOfMilliseconds / (24 * 60 * 60 * 1000)

Time Syntax

Dayna — Fri, 14 Jan 2011 11:32:02 GMT

Perfect! Thank you!