Matt, try Chip Pearson's site:
http://www.cpearson.com/excel/datetime.htm#TOC
************
Anne Troy
www.OfficeArticles.com

"Matt" wrote in message
...
Hi all

Im trying to set up a new timesheet for use at work but dont know much
about formulas etc, i need to put a start and finish time e.g. start 8.30,
finish 12.30, then i need to calculate in a column at the end telling me
how
many
hours ive worked between 8.30 and 12.30 then the same for the afternoon
from 1.30 until 5pm with another column at the ending adding the hours
worked
in the morning to the hours worked in the afternoon giving me total hours
worked that day and the same everyday for the week with a box at the
bottom
giving me total hours worked for the week, please help.
Thanks