>>You seem to be asking about counting work days.
Ya, counting work days, or discounting non-work days. Two sides, same coin.
Thanks Joe. I think the nonweekendhours solution should be good enough for what I need.
Yes, holidays too would be the best. But for practical purposes, excluding Sat&Sun is good enough for this particular problem.
Thanks Everyone !
On 6/7/21 2:12 PM, David Gauthier wrote:
Hi:
I suspect I'm not the first to ask about this but couldn't find anything after googling for a bit. So here goes....
I'd like to get the "age" difference between two times which span either all or part of a weekend but exclude any time that transpired during the weekend.
Example (please pardon the non-timestamp vals here...)
age('Monday-Noon','Prev-Friday-Noon')
would give me '1 day'.
...and...
age('Sunday-Noon','Prev-Friday-Noon')
would give me '12 hours'
You get the picture.
Has this wheel already been invented ?
I don't see an easy way to do this off-hand.
All Ears :-)
Thanks in Advance.
You seem to be asking about counting work days. Am I misunderstanding?
orafce has functions for business calendar with holidays
plvdate.add_bizdays(day date, days int) date
Regards
Pavel
--
Angular momentum makes the world go 'round.