glupoi

Counting hours spent using an item

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

Hi,

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.

 

Giuseppe

Outcomes