m***@mbsoftwaresolutions.com
2018-10-15 21:05:17 UTC
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 start and end time and use Excel's native NetworkDays
function to return the length of time between when we received a ticket
and when we responded. So basically I just want to use Excel's
formula/calculation rather than recreate this in the Fox. Every time I
tried to set it manually from the VFP command window, it failed. See
screenshot with my attempts: https://www.screencast.com/t/BtzVOQLu
My current workaround is to have a simple worksheet with the formula
predefined in a cell and just populate the input datetimes and then grab
the resulting calculation from that NetworkDays(..) cell. I feel like
that's a kludge though, and I'd rather just invoke Excel and
programatically do it raw.
Your thoughts on how to best proceed for this task?
tia,
--Mike
_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/***@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
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 start and end time and use Excel's native NetworkDays
function to return the length of time between when we received a ticket
and when we responded. So basically I just want to use Excel's
formula/calculation rather than recreate this in the Fox. Every time I
tried to set it manually from the VFP command window, it failed. See
screenshot with my attempts: https://www.screencast.com/t/BtzVOQLu
My current workaround is to have a simple worksheet with the formula
predefined in a cell and just populate the input datetimes and then grab
the resulting calculation from that NetworkDays(..) cell. I feel like
that's a kludge though, and I'd rather just invoke Excel and
programatically do it raw.
Your thoughts on how to best proceed for this task?
tia,
--Mike
_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/***@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.