Results 1 to 4 of 4

Timesheet Formula - Time in Lieu

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2008
    Posts
    31

    Timesheet Formula - Time in Lieu

    Please refer attached timesheet.

    I am trying to add IF statement to the current formula both Column H8..H12 and I8..I12, this would calculate minus the normal total hours which is 7.6 (in decimal), if the worker either starts or finishes early than normal time (see D3 & D4). The current formula I already add in H8 to H12 and I8 to I12 which is correct but I need to add IF statement to minus the hours from normal hours per day in decimal (see cell h4).

    I hope you know what I mean as it is hard to explain in English. For your information, I have typed the results in cell B14 to B16 which the value should shown in cell G10 to G12.

    Much appreciated for your assistance.

    Thanks.
    Attached Files Attached Files
    Last edited by holiday4ever; 03-25-2017 at 09:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for Timesheet - Double Time, Time Half and normal Hours
    By Tracs13 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-12-2017, 09:40 PM
  2. Timesheet formula to deduct unpaid time based on value in a column
    By tlstevens in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-16-2015, 04:41 PM
  3. Calculate time in lieu balance
    By mhghg in forum Excel General
    Replies: 5
    Last Post: 04-10-2015, 01:08 AM
  4. In Lieu Time Tracking
    By terriking in forum Excel General
    Replies: 1
    Last Post: 08-29-2013, 02:26 PM
  5. double time formula for timesheet
    By techmob in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2009, 11:21 AM
  6. Show timesheet time in and out in regular time versus military tim
    By John in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-11-2005, 01:20 AM
  7. [SOLVED] Help, How can I deduct time for a timesheet?
    By Jo in forum Excel General
    Replies: 7
    Last Post: 09-20-2005, 05:05 AM

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