#Value Error

C

caldog

Since you folks were so helpful last time I have another question for you.
Say I have two cells A1 and B1 that has the cell formatted as (hh.mm.ss).

Now when I try to subtract those two number I get a #Value error. Why is
that?
 
J

JMB

you still have to key the data in as

hh:mm:ss

to get excel to recognize it as a time. if you are typing the periods ".",
excel will treat it as text regardless of the number format.
 
Top