dReminderTime is the variable for Time.
Do yourself a favor, either use DIM with Option Explicit as first line of code, or don't. I prefer it myself. Before I run code I Compile it. Using Compile (in the VBE's Debug menu) before a run will well, help you debug/catch errors before runtime.
I don't know why you did dReminderTime that way. I guess you got it from my first post where I used a comment to show the string method. I used the following line of code there for that variable for the more reliable method. You are using a variable that does not exist in that line. You have concatenated extra space characters. So, you have two issues with that line of code.
I guess you should change :
to
Of course if E2 is a string, that won't work but then Compile would have showed you that problem. Use CDATE() around string dates when you want to do date math or convert a string to date format.
This "might" work if you want to force Excel to make a guess at date conversion.
Date Time Tests:
I could show you some DateSerial() and TimeSerial() examples too but I think the Time for that might be for another Date...
Bookmarks