Forum Discussion
Calculating difference between two times
Yes there are ways. The solution will depend on your data type, and you will presumably also need to manage the scenario when the day changes. If it were me, I would first make sure the data in the columns is in the format date/time. You can then just do a simple [actual] - [planned] to get the difference. If you format this as a time only, it should format the time as you want. The only issue will be of the arrival time is > 24 hours late.
Yes there are ways. The solution will depend on your data type, and you will presumably also need to manage the scenario when the day changes. If it were me, I would first make sure the data in the columns is in the format date/time. You can then just do a simple [actual] - [planned] to get the difference. If you format this as a time only, it should format the time as you want. The only issue will be of the arrival time is > 24 hours late.
MattAllington - Thanks Matt, the data is in a time format however I did not have the answer [difference] in time format.
Thanks
Giles
