locked
finding the total amount of hours between 2 dates if a value is true RRS feed

  • Question

  • I am trying to determine the amount of hours that have occurred between 2 dates. It is for a safety incident spread sheet and I want to calculate the number of worker hours between a start date and when a lost time incident has happened.  Example:  Start date January 1, 2017, and on July 7, 2017 there was a lost time incident, I can calculate the days between but I would also like to calculate the working hours between the 2 dates.  Also from July 7, 2017 to record the hours until another lost time incident has occurred.  See below for more details, the Microsoft forum advised me to ask in this discussion group.  I have copied what I had asked them below.  thank You

    Friday, September 8, 2017 8:31 PM

All replies

  • I have more details with snap shots of what I am trying to accomplish but can not send until my account is verified.  Thank you
    Friday, September 8, 2017 8:32 PM