View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KerryM1212 KerryM1212 is offline
external usenet poster
 
Posts: 4
Default Creating a formula to display # of work hours spent on a project

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!