Results 1 to 6 of 6

Counting total hours worked within m

Threaded View

  1. #1
    Registered User
    Join Date
    08-03-2007
    Posts
    7

    Counting total hours worked within m

    (Title was supposed to say: Counting total hours worked within multiple days)

    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. Ideally, i'm trying to avoid having a lunch out/lunch in column or having to enter each day into a spreadsheet...

    I'm thinking a datediff equation

    Any ideas would be greatly greatly greatly appreciated.

    Thanks!
    Last edited by umass02; 08-03-2007 at 05:19 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1