=mod() shouldn't cause an error.

My first guess...

If you look at the column headers, do you see A, B, C, ...
or do you see 1, 2, 3, ...

If you see numbers, try changing this:
tools|Options|General Tab|uncheck R1C1 reference style

And reenter the formula.

===
Or maybe =mod() is called a different name. Do you use an English version of
excel?

If not, maybe this will help:

KeepItCool has a translator utility at:
http://members.chello.nl/keepitcool/download.html




a2apple wrote:

start time
11:00:00 PM (A3)
end time
3:00:00 AM (B3)

i am trying to use mod to work out the number of hours that a person
worked using excel

so i used the following formula =mod(B3-A3,1) i keep getting the
following error #Name?

thanks in advance for any help i can get

--
a2apple

--

Dave Peterson