AnsweredAssumed Answered

Calculating Elapsed Time during business hours timeframe

Question asked by ddave on Jul 13, 2016
Latest reply on Jul 15, 2016 by 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

Outcomes