why doesn't sum add time

[jvoortman]

I have a starting time in cell A1 of 5:15, and in B1 I
place :46, and I put sum of A1+B1 in column A3. I don't
get 6:01, but instead I get #VALUE! What am I doing wrong?

 

[Frank Kabel]

Hi
have you entered your times really as time values?. What do the
formulas
=ISNUMBER(A1)
and
=ISNUMBER(B1)
rreturn?

 

[jvoortman]

it does show 13:30 already

-----Original Message-----
The format of the cell is wrong. Highlight all three cells, right click,
format cells,(on number tab), time - use '13:30' as your format.


.

 

[jvoortman]

first formula show TRUE, second one shows FALSE. What does
this mean?

 

[Frank Kabel]

Hi
try entering your second value as 0:46
and it should work

 

[jvoortman]

putting a "o" in it worked great ,,thanks!!!!!!!!