Excel Timesheet

[Matt]

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

 

[Rob Giordano \(Crash\)]

This, believe it or not, is not as simple as one would think...working with
time that is.
Start by working with 24hr clock time.
The rest you should ask in the Excel newsgroup for a more better answer.

 

[Beth Melton]

Like Rob noted, calculating time isn't simple. Check out Excel MVP
Chip Pearson's web site for an extensive list of date/time
calculations:
http://www.cpearson.com/excel/datetime.htm#AddingDates

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/