10 Replies Latest reply on Jul 15, 2016 9:49 AM by ddave

    Calculating Elapsed Time during business hours timeframe

    ddave

      Hello,

       

      So I am trying to calculate total time taken for one job during company's business hours (8am-5pm, Monday-Friday). Now the real challenge for me is to consider only hours during business time and days frame when the ending time is on later date. I found this Calculating Elapsed Time When Ending Time on a Later Day | FileMaker   to calculate total time but I don't want to consider non-business hours and days(sat,sun).

       

      P.S: I have Date started, Time started, Date Ended and Time Ended field values