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" <dougallpool@aol.com> wrote in message 
news:OdEBGLwtKHA.3360@TK2MSFTNGP06.phx.gbl...
> 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
>
>