how to work out the hours worked in excel

[imported_unknown]

hi

i want to know how do u work out the time in excel i.e

an employee comes in @ 10am they have lunch @ 1pm they finish lunch @ 2pm <1 hour lunch> they leave work @ 5pm how can u work out the total time they have worked?????????????in practical the employee has worked 6 hours but how do u get excel to do this

 

[Aladin Akyurek]

Is the lunch time always 1 hour?
This message was edited by Aladin Akyurek on 2002-10-01 15:16