1

Is it possible calculate time having a Date in reports?

Topic: Is it possible calculate time having a Date in reports?

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!

2

Is it possible calculate time having a Date in reports?

Re: Is it possible calculate time having a Date in reports?

It is impossible to do by current functional of Calculator.

Please, clarify why do you want to calculate this time difference.

@ Oleg Zharkovsky
Technical Support / Training Team
"Timely is the best. But still better late than never."
3

Is it possible calculate time having a Date in reports?

(edited by orlo_26 18/01/2019 18:20:53)

Re: Is it possible calculate time having a Date in reports?

zark wrote:

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?

4

Is it possible calculate time having a Date in reports?

Re: Is it possible calculate time having a Date in reports?

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.

Tatsiana Kots
Business Analyst, Gurtam
Join our Telegram Update Channel | Следите за обновлениями на нашем Telegram канале
5

Is it possible calculate time having a Date in reports?

Re: Is it possible calculate time having a Date in reports?

orlo_26 wrote:

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.

@ Oleg Zharkovsky
Technical Support / Training Team
"Timely is the best. But still better late than never."