Thanks, Fred. I was so close!
On 2018-10-15 17:18, Fred Taylor wrote:
ox.Cells(yourrow,yourcolumn).Formula =
[=(NETWORKDAYS(A2,B2)-1)*("17:30"-"9:00")+MOD(B2,1)-MOD(A2,1)]
Fred
On Mon, Oct 15, 2018 at 2:06 PM
wrote:
I forgot to post the formula in text here:
=(NETWORKDAYS(A2,B2)-1)*(
ox.Cells(yourrow,yourcolumn).Formula =
[=(NETWORKDAYS(A2,B2)-1)*("17:30"-"9:00")+MOD(B2,1)-MOD(A2,1)]
Fred
On Mon, Oct 15, 2018 at 2:06 PM
wrote:
> I forgot to post the formula in text here:
>
> =(NETWORKDAYS(A2,B2)-1)*("17:30"-"9:00")+MOD(B2,1)-MOD(A2,1)
>
> I can't get that entered programat
I forgot to post the formula in text here:
=(NETWORKDAYS(A2,B2)-1)*("17:30"-"9:00")+MOD(B2,1)-MOD(A2,1)
I can't get that entered programatically from VFP.
On 2018-10-15 17:05, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
See screenshot: https://www.screencast.com/t/wzLweduy
General s
See screenshot: https://www.screencast.com/t/wzLweduy
General scenario: 2 input datetime values, with output being the native
Excel command NetworkDays result on those 2 cells using 9 a.m. to 5:30
p.m. bounds, giving me the time elapsed between DateTime1 and DateTime2.
I want to supply a sta
4 matches
Mail list logo