SLA Calculation with criteria

Hello all!

I am trying to create a NetworkDays formula that will calculate the Days between two dates but with a certain criteria. The report that I use has the dates in a time stamp format that looks like this... "MM/DD/YYYY HH:MM:SS AM/PM". If the start date has a time stamp before 3:00pm, then the formula should be...=Networkdays(StartDate,EndDate). However, if the start date is after 3:00pm then the formula should be...=Networkdays(StartDate,EndDate)-1.

Can anyone assist with this calculation?


THANKS!!!!!

Hi dwhite30518, will this work for you?

Please Login or Register  to view this content.