Results 1 to 4 of 4

Start and End Times for Both Regular and Overtime Hours from General Hours Worked?

Threaded View

Lawclerk Start and End Times for Both... 04-22-2016, 05:42 PM
etaf Re: 16 Hour Night... 04-22-2016, 06:34 PM
Lawclerk Re: 16 Hour Night... 04-22-2016, 08:58 PM
zbor Re: Start and End Times for... 04-23-2016, 01:42 AM
  1. #1
    Registered User
    Join Date
    04-22-2016
    Location
    Houston, TX
    MS-Off Ver
    2011
    Posts
    7

    Start and End Times for Both Regular and Overtime Hours from General Hours Worked?

    Hi All,

    Our client is a medical professional who essentially got screwed (and VERY overworked) by his employer. I need to know how to draw out overtime start and end times, as well as the regular hour start and end times, from the total times worked for each day he recorded his general hours. Basically pay schedule is tiered like so:

    (A) Weekday regular hours: 7am-3pm (8 hr total)
    (B) Weekdays on call [overtime hours]: 3pm-7am (16 hr total)
    (C) Some weekends on call [overtime hours]: 7am (Sat.) - 7am (Mon.)

    He is also entitled to payment on the weekends as set out in (C), but I can handle that manually if need be. I just really need help setting up a formula to parse out start and end times of (A) and (B) from the generalized hours he gave us in the spreadsheet.

    Very much obliged,

    Frustrated Law Clerk
    Last edited by Lawclerk; 04-23-2016 at 01:09 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to count hours for Night Differential (using IF function)
    By helpme10 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-30-2019, 05:07 PM
  2. [SOLVED] Night Shift Differential
    By vaium in forum Excel General
    Replies: 9
    Last Post: 04-15-2016, 11:05 AM
  3. Computing for number of hours under Night Differential
    By emanon132501 in forum Excel General
    Replies: 4
    Last Post: 09-24-2015, 02:13 AM
  4. [SOLVED] Compute Night Differential Hours
    By UnKnown_25 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-04-2015, 11:17 AM
  5. TIME DIFFERENCE - Calculate Night Differential
    By persnickety in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2013, 12:44 PM
  6. How to calculate Night Differential
    By mar_t in forum Excel General
    Replies: 10
    Last Post: 01-04-2013, 01:55 AM
  7. Replies: 2
    Last Post: 07-27-2012, 04:54 AM

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