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

  • Thread starter TIMEVALUE ERROR
  • Start date
T

TIMEVALUE ERROR

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.
 
T

TIMEVALUE ERROR

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).
 
F

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?
 
D

desperategirl

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.
 
Top