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