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



"Doug AllPool" wrote in message
...
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