time is not be extracted correctly

good morning,

i have a little problem. i couldn't find anything that can help me in my situation.

i have extracted the date and the time from a cell where was both inside.

it looks like it is correct, but if i write the same date and the same time by hand in other cells and let the macro compare them, it says the date is correct but not the time. i tried formatting it in different ways. hh:mm:ss is the way i need but other formattings like hh:mm or h:mm:ss doesn't work either.

https://www.excelforum.com/attachmen...1&d=1516084679

i should add another informations: the upper button "Zählen" is the button to extract the date and the time.
and after the extraction, if i click into the cell where the time has been extracted to to edit it and then compare it with the macro "Rüstwechsel"-button it works

Thanks and greetings

Attach your file HERE.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

If you are referring to E2 and F2 being extracted from F2, then they are correct date and time. What is not being done correctly for you?

To extract the date, you could use...
=INT(D2)
and for the time...
=MOD(D2,1)
format each as needed

I get "correct" when I try your code?

Aslo, keep in mined that when dealing with time, it is a decimal of 1 (day), and as such, could be up to 14 decimal places, but only show a few minutes. if the compare is not exact out to that many decimals, it will return FALSE. perhaps try rounding them both to, say, 10 decimals?