VBA code to Subtract values in Column F with Column E if found non-blank

**hydz1213** · 03-05-2013, 03:12 AM

Please can anyone give me a code that will subtract NOW() values in column F with the NOW() values in column E and populate the answer in column I of the worksheet. I'm doing this to determine the # of working hours of each staff.

The reason I want a code and not regular formula from excel sheet is that the entries for this worksheet (Admin) will be coming from another worksheet (User). And I want this code to calculate only upon opening of the Admin worksheet.

Please support. Thanks in advance!

**arlu1201** · 03-05-2013, 03:18 AM

So you want the code to be in a separate workbook? Do you want the code to open the file containing the Admin worksheet?

**hydz1213** · 03-05-2013, 03:25 AM

Originally Posted by arlu1201

So you want the code to be in a separate workbook? Do you want the code to open the file containing the Admin worksheet?

Hi arlu1201,

I want the code to be written in the Workbook_Open() of Admin.xlsm in which I will manually open only at the end of each week to see the working hours of staff.