Hi,
I have an excel file to record and track daily updates.
I need a VB code that would update current date and time when user update a status.
Have attached referenced excel.
Requirements:
1. Update current date and time on basis of comment
i.e. In Process, Pending and Done.
2. Calculate total Processing Time for every entry excluding weekend
i.e. [Done Time - Receipt Date/Time] - [QueryOutTime - QueryIn Time]"
Thank You.
Regards,
RahulM
I have an excel file to record and track daily updates.
I need a VB code that would update current date and time when user update a status.
Have attached referenced excel.
Requirements:
1. Update current date and time on basis of comment
i.e. In Process, Pending and Done.
2. Calculate total Processing Time for every entry excluding weekend
i.e. [Done Time - Receipt Date/Time] - [QueryOutTime - QueryIn Time]"
Thank You.
Regards,
RahulM