There are three VBA functions -- Time which returns the current time of day (without date information).
Date which returns the current day without time of day information.
Now which returns both date and time information.
I would replace your use of Time with Now in the statement that writes the current date/time to D2. The other thing I would do is write the data to Excel as a double rather than a text string to avoid any mistakes Excel might make in interpreting date/time text strings. Instead of Format(), I would use CDbl()
Does that work better?
Bookmarks