Re: Need to omit time during weekends from age calculations

On Mon, Jun 7, 2021 at 2:01 PM David Gauthier wrote: > 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. > I've solved th

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&S

Re: Need to omit time during weekends from age calculations

po 7. 6. 2021 v 21:17 odesílatel Ron 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 >

Re: Need to omit time during weekends from age calculations

Joe Conway writes: > On 6/7/21 3:12 PM, David Gauthier wrote: >> 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. I'm a bit suspicious of this problem statement. I doubt there are ma

Re: Need to omit time during weekends from age calculations

On 6/7/21 3: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 transp

Re: Need to omit time during weekends from age calculations

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 transp

Need to omit time during weekends from age calculations

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 pardo