Excel 2007 : Time Sheet

**CPX2** · 02-28-2010, 04:51 PM

I am trying to make a time sheet that will calculate the hours if I enter the time periods. From then I am trying to make it add up the hours weekly and minus a half an hour, if the time period is over 7 hours. Can someone show me where to start?

**jeffreybrown** · 02-28-2010, 05:12 PM

Hi & Welcome to the Board,

Could something like this work for you?

C5 = Begin Time
D5 = End Time

=IF((D5-C5)>TIME(7,0,0),D5-C5-TIME(0,30,0),D5-C5)

**CPX2** · 03-01-2010, 11:39 PM

how exactly are you suppose to enter information into a cell as a time

**Paul** · 03-02-2010, 12:21 AM

Hi CPX2, welcome to the forum.

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your issue.

Secondly, if you Google™ "time sheet in excel" you will get many examples of free time-sheet templates for Excel (from microsoft.com, vertex42, download.com, techrepublic.com, and links to other instructive time-sheet formulas such as as cpearson.com, calculatehours.com, etc.).

I'm sure one will meet your needs, and if any customization is necessary we can likely assist.