I need to monitor how many hours our video projectors are being used every day.
In a invoice layout I'll have
- name of the projector
- starting date and time of usage
The starting date is a text field with a creation of a Timestamp (Date and Time).
Same for the ending date.
At this point I need to store the time passed in a calculation field (?).
If so, what is the formula to extract the hours used for the week, by different films projections?
I'd love to see the end result in a layout where every projection session is showing the hours used for it.
Thanks for your knowledge.