hi Ken, is it formated as text?

i have been tryed id here and works =00:05:41

hth
regards from Brazil
Marcelo

"ken" escreveu:

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.