Counting hours spent using an item

Discussion created by glupoi on Aug 10, 2017
Latest reply on Aug 10, 2017 by philmodjunk


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
  • ending


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.