Discussion board where members can get started with Qlik Sense.
I'm having problems with this:
I have a table with 2 columns with entry times (Hora_ing) and out times (Hora_sal).
When i do the subtraction of Hora_sal and Hora_ing it works.
But when the "truck" come to the place at 23:00:00 pm and lives at 00:00:01 am and after, my problem starts.
the fields in blue are expression Hora_sal - Hora_ing and the times are negative and i need positives values, im trying to make a expression like:
if(Hora_sal-Hora_ingr < time#(00,'hh'), Hora_sal-Hora_ing = (Hora_sal-Hora_ing) + 24 ) and other stuffs but nothing works to me.
Go to Solution.
Yes just do it like this:
Time(EndTimeStamp - StartTimeStamp, 'hh:mm:ss')
Do you still have the timestamps of which you based the times? If so, use those for your calculation.
I think it would be better if use a TimeStamp (which include date field) to do this calculation because then it would know if it is the next day you are subtracting it for. Do you have a field which specifies date?
the original Excel data, has a column with data and time, and i separate it into 2 columns.
You suggest to use the original column
yes i have in other column, but i dont know how to use it
Thank you very much!! it works for me!