Creating a formula to display # of work hours spent on a project

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wasn't quite sure where to put this question.

Is there anyway to calculate the # of work hours spent on a project given 2
seperate dates and times, taking into account a work day of 8-5 with an hour
lunch?

For example, if I work 8-5, start a project on 8/3 at 9 and finished it on
8/7 at 4, the answer would be 22 work hours.

Any ideas would be greatly greatly greatly appreciated.

Thanks!
 
If you have Excel 2003, you can download
Wekly Timesheet (8/12x11, landscape)

Allows you to plug in the information and calculates the info for you...

Another thing is to do this..

A B C D E
In Out Lunch In Lunch Out Hours Worked
9:00 am 12:00 pm 1:00 pm 5:00 pm =(b-a)+(d-c)

And make sure all fielsds re formatted as Time.
 
Back
Top