F
fi.or.jp.de
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.
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.