Maybe I'm missing something but why use Mod? Time is stored as decimal
values.
(3PM - 11AM) will be evaluated by Excel as (0.625 - 0.45833)

Mod returns the remainder of after division.
In this case the "remainder" after dividing by 1 (a day) gives you the same
results as simply doing the subtraction (which will still be a decimal
value)

If you want a "hours worked" result in whole hours, something like:
Int((B3-A3)*24)

HTH,
--
George Nicholson

Remove 'Junk' from return address.

"a2apple" wrote in message
...

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