• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA code to update current date/time and calculate processing time

RahulM

New Member
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
 

Attachments

  • Tracker.xlsx
    13.1 KB · Views: 6
Dear dEEPAK,

This suffices the requirement.

I don’t know anything of VBA coding but have used this code by modifying to meet all current requirements, except ‘Processing Time’ calculation.
Just trying to figure out if this can also be coded in VBA.


Nevertheless, Thank You Very Much for taking time to answer.

Regards,
RahulM
 
Dear dEEPAK,

This suffices the requirement.

I don’t know anything of VBA coding but have used this code by modifying to meet all current requirements, except ‘Processing Time’ calculation.
Just trying to figure out if this can also be coded in VBA.


Nevertheless, Thank You Very Much for taking time to answer.

Regards,
RahulM

Good to know it helped!!
Pls let me know what can i do for you @ "Processing Time"
 
Back
Top