Hi,
created the cells with time format A and date format B and general C and got #value! so made C number format 2 dec places still get #value!

ah solved it, I had done a test lower down and of course the row numbers are not 1 and 1, silly me !



DBenz

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.