Results 1 to 11 of 11

Need help with an hour calculating timesheet... please!

Threaded View

  1. 03-04-2015, 06:16 PM #7
    jjhayes
    jjhayes is offline
    Forum Contributor
    Join Date
    06-18-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    142

    Re: Need help with an hour calculating timesheet... please!

    I played with the if formulas to first check if hours for the day will go make cumulative hours for week to go over 44, then a second check to see if total hours for day are greater than 8...I think this is working for calculating overtime per your requirements. Does it work for you?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 24-hour clock timesheet help
    By utahcorvettenut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2015, 07:25 AM
  2. Excel timesheet for quarter hour
    By ZNLOZ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-27-2011, 04:54 AM
  3. Excel 2007 : calculating sums every 1/2 hour over 12 hour period
    By mcfarcry in forum Excel General
    Replies: 4
    Last Post: 10-14-2010, 03:31 PM
  4. Rounding Timesheet to quarter hour
    By djknight2007 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-30-2010, 01:12 PM
  5. 24 Hour Format For Timesheet
    By faisca_aem in forum Excel General
    Replies: 3
    Last Post: 06-29-2006, 10:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1