Results 1 to 6 of 6

Calculating hour outside core hours when all hours fall outside core

Threaded View

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    Loxton
    MS-Off Ver
    Excel 2013
    Posts
    3

    Arrow Calculating hour outside core hours when all hours fall outside core

    I am trying to set up a time sheet for staff where it calculates hours worked in and outside of core hours. I can do a calculation to work out what they have worked in and out of core hours providing that part of their time starts of finishes in core times. The problem I am having is when some one works only outside core hours. Our core hours are 6am to 6pm. The problem is when they work from say 7pm to 1am. This is irregular work paid as overtime not shift work.

    Thanks for any help
    Last edited by JBeaucaire; 04-22-2014 at 02:12 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate overtime outside core hours
    By Val C in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-26-2013, 05:33 AM
  2. Calculating actual hours worked only in core hours
    By Val C in forum Excel General
    Replies: 3
    Last Post: 02-27-2013, 01:54 AM
  3. [SOLVED] How to Calculate time outside core hours regardless of Days
    By mehulsagar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-09-2012, 06:31 AM
  4. Replies: 1
    Last Post: 11-29-2011, 12:19 AM
  5. Excel CPU Usage - Single Core/Multi Core (balanced/unbalanced?)
    By winstontj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-03-2010, 07:22 PM

Tags for this Thread

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