Вы не вошли. Пожалуйста, войдите или зарегистрируйтесь.
To give you an example, I have the following column:
Start
----------------------------
2019-01-16 20:00:24
And I want to know the time between 18:00:00 (that same day) and the date above.
Expected result: 02:00:24
Is this possible adding a Calculator column maybe? I have tried but couldn't get what I expected.
Thanks so much!
It is impossible to do by current functional of Calculator.
Please, clarify why do you want to calculate this time difference.
It is impossible to do by current functional of Calculator.
Please, clarify why do you want to calculate this time difference.
Thanks for your answer!
Well, we need to calculate the over time that drivers do. The time after 18:00 should be considered as Over Time. Its important to say that we need to add the trips and parking time before the last trip.
Example:
Trip1 2019-01-16 17:00:00 -- 2019-01-16 19:00:00
Parking 2019-01-16 19:00:00 -- 2019-01-16 19:30:00
Trip 2 2019-01-16 19:30:00 -- 2019-01-16 20:00:00 (last trip of the day)
So, we need to get somehow that the over time this day was: 02:00:00 (2 hours)
Did I make myself clear? Maybe there is another way to do that. Can someone help me?
orlo_26, we've added a new table type recently: Trips for drivers.
So I recommend you to try it. Use different Time limitation setting for two tables to separate trips by time (see the attachment). Use interval 9:00-17:59 interval for one table and 18:00-23:59 for another. The option "Cut off interval" will divide trips between two tables without information duplications.
Well, we need to calculate the over time that drivers do. The time after 18:00 should be considered as Over Time.
As an alternative you can try to add several shifts in report template and grouping by shifts in the table.
