8 Replies Latest reply on Aug 30, 2016 11:18 AM by Tracy Orwig

    Difference of hours between a set time and an end timestamp

    Tracy Orwig

      I have data for a list of people showing their start and end times.  I need to find how many hours they worked after 9pm each day they have worked.  I have a filter that shows those who had a end timestamp after 9pm but I have yet figured out how to get a static time of 9pm to find the difference in the hours.  I am sure it's doable but I haven't yet figured out how to create a static timestamp of 9pm to subtract their end timestamp.

       

      thanks in advance for your help!