time arithmetics

[Mark in miami]

I'm using Excel 2000. I need to set up a basic timesheet
calculating worked hours based on arrival time, end time
and break (entered as 1 for 1 hour), etc.

I'm having a difficult time determining the correct
function to help. Here is an example of an entry:

Arrive:9:00 AM; Leave: 5:00 PM; Break: 1

Please help...

thank you,
Mark

 

[Andy B]

Hi

If your data is stored as Excel time, you can just subtract the figures:
Time = Leave - Arrive - 1
For more info see here:
http://www.cpearson.com/excel/datetime.htm#WorkHours