View Single Post
 
Old 01-26-2017, 05:38 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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.
Reply With Quote