Hi,

This is for Excel 2003. The requirement is:

First column (say A1) will have a date time in mm/dd/yyyy hh:mm:ss format (e.g. 02/02/2010 09:10:00),

Second Column (say A2) will have a frequency time in minutes e.g. 30 minutes

I need to sum A1 and A2 to populate A3, A4 value should be (A3+A2), A5 value should be (A4+A2) etc. this recurring calculation should be done for a 24 hours period starting from the date time value given in A1

How to achieve this in Macros? Advances thanks you for your help/inputs