Dato format - time info not getting saved in variable

Do you really need to fix it?
If it is a genuine date

Please Login or Register  to view this content.

Or if you need it how it looks regardless of the data type then use .Text property

Please Login or Register  to view this content.

Hi.

Thanks for your reply.

Yes, I need to fix it since I do a date comparison so 00:00 is bigger than f.ex 22.00 and when its nothing it assumes that its bigger.

I also see now that the value that's actually in the cell also have seconds. So when it saves the other variables it comes with milliseconds.

Your Range("N" & t).Text seems to work but I adjusted your Format idea so it also includes the seconds. Just in case and then it gets 100% correct. (I think)

Please Login or Register  to view this content.

Then why not convert it to a numeric value to compare?
e.g

Please Login or Register  to view this content.