This doesn't 'answer' your question, but it may help.
Microsoft has some cool templates that you might be able to use right 'out
of the box' or use to 'study'.

http://office.microsoft.com/en-us/te...377091033.aspx

Or, to navigate there manually, go their templates, microsoft Office
Programs, Excel, Business, then Payroll.

The very last template there 'Weekly Work Schedule' is what I often use.

Good Luck!

"Keely" wrote:

I have a follow-up to the original question. What if I need to subtract time
out of the elapsed time. Specifically, if an employee works more than 6
hours, then he/she will take 30 minutes for lunch. So the correct "hours
worked" for a 9:00 AM to 5:30 PM shift is 8 hours, not 8 hours and 30
minutes. I can write the logic for the if/then statement, but I cannot
determine how to indicate that 30 minute subtraction.

Thanks!
~keely


"Peo Sjoblom" wrote:

=end_time - start_time

format as time or use

=(end_time - start_time)*24

and format as general

--

Regards,

Peo Sjoblom

"Greg" wrote in message
...
what is the formula for adding time?
For example, I would like my timesheet to automatically add the time I
worked by
adding the time I arrived to the time I left and put the amount of hours
in
a total
column. In other words I would like to enter 9:00 AM and 5:00 PM and
have
the
total show 8.

thanks in advance
Greg