Difference in Working Hours

[Scheruku]

Hi,

We are trying to calculate the difference in working hours between second time and subsequent row entry time file after sorting ascendingly for the same vehicle no...the first row second time - subsequent row entry time

I'm facing difficult in using the multi row formula for calculating the no of hours

Best Regards,

[danrh · Accepted solution]

Something like the attached? 

Note that the RecordID at the beginning and the Sort at the end are just to maintain the order of the records.  They aren't completely necessary.

[Scheruku]

Hi,

Thank you for the solution. It's working great!

Just wanted to check how can we get the difference in hh:mm:ss format 

[danrh · Accepted solution]

Take a look at the attached workflow:

[Scheruku]

Hi,

I'm trying to extract only those records that are less than 4 hours and get the corresponding details too..

Could you please help.

[danrh]

Something like this in a Filter tool should do the trick:

Left([Time Difference],2) IN ('00','01','02','03')
OR
[Time Difference] = '04:00:00'

Note that this is LESS THAN OR EQUAL TO.  If you want just less that, remove everything from "OR" on.