Macros In Excel

[Ribs7774]

Hi,

I need a marco that can check if a date & time entered is over 48Hours & if it is to delete the data in this row.

Example:
Time Set for entry is = 02/01/2014 12.00

After 48 Hours has expired > 04/01/2014 12.01

This row is deleted.

If the entry has not expired the row is to remain until it has expired.

There maybe up to a couple hundred entries, so manually checking is not ideal, but I believe a macro can do the trick just not sure how to setup the marco script.

Thanks in advance for your assistance

 

[Ribs7774]

Thanks

I had to make an adjustment to allow for a different time zone but that was pretty easy.


Thanks again for you assistance