Hi guys,
I think this is a fairly simple issue, or so i hope.
Column D of my spreadsheet, contains between 400-500+ records in format: dd\/mm\/yyyy hh\:mm
What i would like to do is write a piece of VBA code that loops through the values in Column D, and add a specified amount of time to it.
The specified amount of time is stored Sheet2 E2 of the current workbook - for example 5:30 hours.
So, if i had an original date time of 09/11/2012 10:00, the new value would be 09/11/2012 15:30.
Any help appreciated.
I think this is a fairly simple issue, or so i hope.
Column D of my spreadsheet, contains between 400-500+ records in format: dd\/mm\/yyyy hh\:mm
What i would like to do is write a piece of VBA code that loops through the values in Column D, and add a specified amount of time to it.
The specified amount of time is stored Sheet2 E2 of the current workbook - for example 5:30 hours.
So, if i had an original date time of 09/11/2012 10:00, the new value would be 09/11/2012 15:30.
Any help appreciated.