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?
My Visual Database → General → 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?
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.
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
My Visual Database → General → How to calculate time difference?
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi