Why am I getting #VALUE! when working with a TIMEVALUE formula?

[Guest]

This formula is working on other pages within the same workbook, yet it does
not work on a newly inserted worksheet. NOTE: this orginial workbook was
created in an early version of Excel (95 or 98), now using 2000.

 

[Frank Kabel]

Hi
what is your exact formula and what is in the referenced cells?

 

[Guest]

The formula is =MOD(TIMEVALUE(D9-C9)+(F9-E9),12). It is being used to
calculate hours on a Timesheet. C9 thru F9 are times (8:00 am).

 

[Frank Kabel]

Hi
TIMEVALUE would expect a string as parameter. I doubt that D9-C9 would
result in a string value though

So maybe you mean
=MOD(D9-C9+F9-E9,12)

not sure what you're trying to achieve with this MOD function though.
Restrict the value to 12 days?

 

[Guest]

One of the values in your "total" has probably been deleted. Check to make
sure all of the cells you want totaled, still have the correct data in them.