Topic: How to calculate time difference?
A table has StartTime and EndTime of activity in DateTime format. How can I calculate the time spent in the activity?
- derek
- Moderator
- Offline
Re: How to calculate time difference?
Hi Eyeman,
Please have a look at the attached as one way of doing it.
Obviously, if your activities don't span more than 1 day, you could amend the script accordingly to make it a bit more concise..
Regards,
Derek.
Post's attachments
duration.zip 338.31 kb, 293 downloads since 2020-04-05
Re: How to calculate time difference?
Hello Derek,
Thank you once more. Amazing program. Solves all the duration queries. Will need some study time, to fully understand the script.
Regards,
eyeman