Re: Need to omit time during weekends from age calculations

>>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 Mon, Jun 7, 2021 at 3:46 PM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
wrote:

>
>
> po 7. 6. 2021 v 21:17 odesílatel Ron <ronljohnsonjr(at)gmail(dot)com> napsal:
>
>> 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
>
> https://github.com/orafce/orafce
>
> plvdate.add_bizdays(day date, days int) date
>
> Regards
>
> Pavel
>
>
>> --
>> Angular momentum makes the world go 'round.
>>
>