+ Reply to Thread
Results 1 to 3 of 3

Timesheet Problem, display 9am if staff come in earlier

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    2

    Timesheet Problem, display 9am if staff come in earlier

    I'm made a timesheet for work. The problem is that employees come in early - so they sign in prior to 9am. When they work until 5, the sheet caluclates the 10 or 15 min as overtime... the problem is, our staff only get PREapproved overtime, so these early mornings are adding up when they shouldn't be.

    I would like to show the actual time in with another column, beside it that displays either 9am if it before 9, or the actual time in if it is after 9. I'd like to do the same, for actual time out - if it is after 5pm, to display 5

    Can anybody help?
    J

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Timesheet Problem, display 9am if staff come in earlier

    Use

    =MAX(A1,9/24)

    where A1 holds the input time
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    05-21-2014
    Posts
    2

    Re: Timesheet Problem, display 9am if staff come in earlier

    Awesome! You just made my day, thank you

+ 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. [SOLVED] Macro to update Score Card Summary when the new staff add-in or existing staff deleted
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-12-2014, 02:43 PM
  2. Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet
    By Marie Snell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 11:04 PM
  3. Problem using formulas from earlier excel versions
    By Tonyinoz in forum Excel General
    Replies: 3
    Last Post: 01-28-2012, 04:07 AM
  4. Staff Hierarchy Problem
    By ot070707 in forum Excel General
    Replies: 2
    Last Post: 10-21-2011, 01:38 AM
  5. Problem saving to earlier version with macro
    By Big Chris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2008, 06:17 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