auto fill time based on a when a specific cell has data entered

Good afternoon

Is there a way that column AU (time) can auto fill based on when an entry is made in column D (type) in the spreadsheet that I have attached please?

A simple solution is out there I'm sure thank you in anticipation

Kind regards

Damion

I hope this helps you.

http://www.excelforum.com/excel-gene...-and-date.html

hi Danny

Thanks for the thread link

However i truley am a numpty when it comes to macro and i can see the code is referring to row 1 and row 2 how do i change it so it would work in columns and on my spreadsheet as obviously i would need to change the wording in the macro to get it to look at the correct cells?

sorry to ask again