Formula for adding time

  • Thread starter Thread starter Doug AllPool
  • Start date Start date
D

Doug AllPool

Are all the cells formatted for time? I have them all formatted for time
(13:30) and
I get " #VALUE! " in the cell with the formula.

Doug
 
If you get a #Value error, it means you don't have a time stored in the
cell. Formats change only the appearance of the cell, they don't change the
underlying data. To get a time, you have to enter it so Excel will recognize
it as a time. It must contain a colon; if you are using am/pm, there must be
a space in between, etc.

What are you actually entering in the cell?

Regards,
Fred
 
Back
Top