+ Reply to Thread
Results 1 to 2 of 2

If for OT - probably easy for someone

  1. #1
    Registered User
    Join Date
    10-28-2008
    Location
    Chicago
    MS-Off Ver
    MS365 - 2211
    Posts
    94

    If for OT - probably easy for someone

    This is probably very easy, but for some reason I am slightly having an issue.

    I am needing to schedule labor services and I am attempting to budget the amount for services on the schedule. I am attaching an example of what I am attempting to do. Basically I am going to make multiple copies of this same little box for each day. For the attached workbook I want to fill in the number of guys I need for each department in B4:B7. I then want to fill in the times I want them scheduled to work. Fairly straight forward to this point.

    The M4:M7 list the total hours per group per day. This particular place I am going charges time and a half after 8 hours. I am trying to make one column O4:O7 show me the total number of OT hours. Basically I want it to say if "M?" is over 8 fill in "N?" with the amount that it is over. So N4 would show up as 2 in the attached example. I then will make columns to determine the costs at each rate.

    Is this something someone can help me with?

    Thanks
    Matt
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: If for OT - probably easy for someone

    see the attached file
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I think this must be easy!
    By Masterplan in forum Excel General
    Replies: 1
    Last Post: 08-06-2009, 02:56 PM
  2. Easy one I think?
    By drums4monty in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2006, 07:07 PM
  3. This is probably an easy one
    By lancekeith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2006, 03:22 PM
  4. This should be so easy...
    By Crazy in forum Excel General
    Replies: 6
    Last Post: 12-05-2005, 04:12 PM
  5. new user with easy question? not easy for me
    By speakeztruth in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-03-2005, 05:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1