1 Reply Latest reply on Aug 10, 2017 8:40 AM by philmodjunk

    Counting hours spent using an item

    glupoi

      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

        • 1. Re: Counting hours spent using an item
          philmodjunk

          The starting date is a text field with a creation of a Timestamp (Date and Time).

          Same for the ending date.

          That's a mistake there. Make the two fields, fields of type timestamp, not text.

           

          Then EndingTimestamp - StartingTimeStamp will give you the elapsed time in seconds. You can specify a time result type to display the result as HH::MM::SS or you can use a number result type but divide by 60 to get elapsed time in minutes or by 3600 to get elapsed time in hours.