I think that I have finally figured it out. When I manually enter the data
it works. I will have to write a macro or something to convert from string
to date format.

"Biff" wrote:

Check and make sure that the entries are in fact real Excel dates/times.

Try these tests:

=ISNUMBER(B8)
=ISNUMBER(C8)

Both should return TRUE.

If either or both return FALSE....

Select either B8 or C8
Goto the menu DataText to Columns
Select Delimited
Click Finish

Repeat for the other cell if needed.

That might convert the entries to real dates/times.

Biff

"ken" wrote in message
...
I have tried many different formats and formulas and the worksheet will not
calculate the difference between two times formatted as follows.

6/12/2006 8:03:14 PM 6/12/2006 8:08:55 PM #VALUE!
B8 C8

the formula I used is =C8-B8 and I continue to get #VALUE!!!!!!!!!

I have read the Excel help and it did not help.