Netwrokdays in VBA
 

Hi All,

I have created userform, I need some help on this !

We have APAC, US regions.

Start date & time AND end date & time captured in userform ( those
data stored in MS Access )

Eg : Start date & time ( mm/dd/yyyy hh:mm:ss )

US region timing 5.30 PM - 2.30 AM ( Indian Standard Time )

If user gets request Within US region time then end minus start -
total time will be captured.

If user get request after US region time - user will update the
userform whatever the time

he received the request. Say 4:30 AM ( IST ) at this time, US Market
closed.

Once the US market open we proceed with our work.

Total time for the above case will be different because request
received after US region time.

Eg,
Received time - 4.00 AM IST
Completed Time - 8.30 PM IST
Total time taken to complete - 0 days 3 hrs ( as it is on the same
day ). Because Received after US region time Time Starts from 5.30 PM
IST.

NOTE : there are cases where requested completed after a week also.

So, Answer should be in days & hrs ( only Business Days )

I Need VBA Soultion.

Thanks in advance.

Netwrokdays in VBA
 

The networkdays function is available in VBA, but that function does not
calculate fractional parts of days.

In addition, this may be a lot more complicated that you seem to make it.
what if it is a holiday in India, but not in the US, or visa versa? What if
it is a weekday in US but a weekend in India or visa versa?

And what about the multiple time zones, there are many in the US and I
suppose many in India?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"fi.or.jp.de" wrote:

Hi All,

I have created userform, I need some help on this !

We have APAC, US regions.

Start date & time AND end date & time captured in userform ( those
data stored in MS Access )

Eg : Start date & time ( mm/dd/yyyy hh:mm:ss )

US region timing 5.30 PM - 2.30 AM ( Indian Standard Time )

If user gets request Within US region time then end minus start -
total time will be captured.

If user get request after US region time - user will update the
userform whatever the time

he received the request. Say 4:30 AM ( IST ) at this time, US Market
closed.

Once the US market open we proceed with our work.

Total time for the above case will be different because request
received after US region time.

Eg,
Received time - 4.00 AM IST
Completed Time - 8.30 PM IST
Total time taken to complete - 0 days 3 hrs ( as it is on the same
day ). Because Received after US region time Time Starts from 5.30 PM
IST.

NOTE : there are cases where requested completed after a week also.

So, Answer should be in days & hrs ( only Business Days )

I Need VBA Soultion.

Thanks in advance.