calculate difference between two times
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.
|