That tells me the time/date may not actually be numbers.
You can verify this by using ISNUMBER
Try...
=ISNUMBER(A1)
Do you get false or true? Try this also with what's in B1.
If you get false, you may have a time/date which looks like a number, but in reality is text. You need to convert to text or check to see if you have any extra spaces.
|