TIMESHEET

[IC]

Can someone tell me the formula that calculates how many
hours you worked for the day based on a timesheet that
includes Monday through Friday, In & Out times which
includes lunch?



Thanks!

 

[Frank Kabel]

Hi
as a starting point:
http://j-walk.com/ss/excel/files/timesht.htm

 

[Guest]

Thanks Frank!

Perfect but can you give me the formulas used to calculate
this sheet.

 

[Frank Kabel]

Hi
they are within this sheet. just have alook at them after you
downloaded John's example files

 

[Paul B]

Download the file, click on Download the Employee Time Sheet Template
(297K), on the page, unprotect the sheet and you can see the formulas
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **