VB Code to confirm and add Total hours worked.

[rizmomin]

Hello:

Please refer to attached file.

I have clockIn-Out info for employees as shown.
I need a VB Code to update the # of numbers worked by employee after making adjusment in ClockIn-Out info.

Currently the data is retrieved in excel as shown.
Now after making changes in clockIn-Out info for employee, the corrected hours worked are as shown in
Range AC1:AK20.

I need to change data for all dates in cell for example: B3,B4,B9,B15,B16 and so on for 8/11/2014 so that it matches Range AC1:AK20.
Same for other date.

Let me know if you have any questions.
Thanks.

Riz

[xladept]

Hi Riz,

Try this:

Please Login or Register  to view this content.

[rizmomin]

Hi xla:

Works fine, except small tweaking.
I need the hours worked as decimal, example 3:54 needs to be 3.90
Please let me know if you have any questions.
Thanks.

Riz

[xladept]

Hi Riz,

Maybe:

Please Login or Register  to view this content.