Results 1 to 5 of 5

Need a formula for Employee Time Sheet

Threaded View

infantryman Need a formula for Employee... 07-31-2015, 10:14 PM
FDibbins Re: Need a formula for... 07-31-2015, 10:26 PM
infantryman Re: Need a formula for... 08-01-2015, 12:04 AM
FDibbins Re: Need a formula for... 08-01-2015, 12:46 AM
infantryman Re: Need a formula for... 08-01-2015, 01:00 AM
  1. 07-31-2015, 10:14 PM #1
    infantryman is offline
    Registered User
    Join Date
    07-31-2015
    Location
    Kingston, ON, Canada
    MS-Off Ver
    Microsoft Office 2010
    Posts
    3

    Need a formula for Employee Time Sheet

    Hello!

    I was wondering if someone could help me find the formula that can solve this problem. To be simple, I want column E automatically removes 30 minutes if the total hours exceeds 8 hours or more. If the total of hours is 7:59 or less, 30 minutes must not be removed. Cells format is [H]:mm. Also, I am using the 24hrs format instead of am/pm.

    D4 - C4 = E4 then - 30 minutes only if the total is 8hrs or more.
    D5 - C5 = E5 (same)
    D6 - C6 = E6 (same)
    etc, etc, etc .....

    Capture.JPG
    Last edited by infantryman; 07-31-2015 at 10:24 PM.
    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. Generate output employee data from input employee sheet
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2015, 05:28 PM
  2. Employee Time Sheet
    By Ed Pankow in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-09-2013, 11:09 AM
  3. Employee Daily Goal Sheet By Time Frame/Shift/Percentages
    By NateBurgher in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2010, 01:04 PM
  4. help : extracting data to create a table (employee time sheet)
    By conuk in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-14-2009, 02:26 PM
  5. employee time sheet
    By gomumy97 in forum Excel General
    Replies: 5
    Last Post: 10-29-2007, 01:20 AM
  6. employee time sheet hours
    By dude2125 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-28-2007, 10:20 AM
  7. [SOLVED] I need an Excel bi-weekly employee time sheet template
    By Books in forum Excel General
    Replies: 5
    Last Post: 04-03-2005, 08:06 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