D
Denny Knepper
I am trying to calculate how much time it takes, in hours and minutes, to
process a transaction when the start time occurs on one day and time and the
end-time occurs a day or two later. The processing time needs to exclude
weekends and non-working hours.
I have been trying to use the NETWORKDAYS function and have a list of
holidays.
I can get the total elapsed hours between the two days but run into problems
when trying to deduct the non-working hours during the week and the weekends
and holidays.
process a transaction when the start time occurs on one day and time and the
end-time occurs a day or two later. The processing time needs to exclude
weekends and non-working hours.
I have been trying to use the NETWORKDAYS function and have a list of
holidays.
I can get the total elapsed hours between the two days but run into problems
when trying to deduct the non-working hours during the week and the weekends
and holidays.