It's possible to convert a Datetime for a Time format greater than 24 hours using Script ?
Ex.: 04/01/1900 05:02:08 -> 101:02
one possible solution could be to format your datetime excel column as Interval when loading in QlikView:
The difference between the 101:02 respective 125:02 interpretation is due to a Leap year bug in Excel that considers 1900 as leap year despite it is not.
Software not sharing this Excel "feature" (e.g. QlikView) presents a date with decimal value 4 as 03/01/1900:
LOAD Timestamp(Datetime, 'DD/MM/YYYY hh:mm:ss') as Datetime,
Num(Datetime) as decimal,
Interval(Datetime) as Interval
(ooxml, embedded labels, table is Sheet1);
hope this helps
The correct is 101:02
And if i have a date like this:
This function doesn't work...
It's a hard problem with format value in Excel...