Time Syntax

[Dayna]

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

[#2 · Accepted solution]

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)

[Dayna]

Perfect! Thank you!