if you look at the column headers you see A, B, C; and i am using a
norwegen version of office 2003 i downladed the file you referd to but
execl will not alow me to install it.

Omar Elroubi



Dave Peterson Wrote:
=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


--
a2apple

Try REST(). I found something that gave a "translation".

"a2apple" wrote:


if you look at the column headers you see A, B, C; and i am using a
norwegen version of office 2003 i downladed the file you referd to but
execl will not alow me to install it.

Omar Elroubi



Dave Peterson Wrote:
=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


--
a2apple

Just to add to Barb's response...

Excel's VBA is USA centric. You can use that to your advantage.

Select an empty cell in a worksheet (not A3 or B3, though!)
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:

activecell.formula = "=mod(B3-A3,1)"

Then back to excel to see how it was translated.



Barb Reinhardt wrote:

Try REST(). I found something that gave a "translation".

"a2apple" wrote:


if you look at the column headers you see A, B, C; and i am using a
norwegen version of office 2003 i downladed the file you referd to but
execl will not alow me to install it.

Omar Elroubi



Dave Peterson Wrote:
=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


--
a2apple


--

Dave Peterson