+ Reply to Thread
Results 1 to 3 of 3

Site basic hours calculating wrong

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    Derby, England
    MS-Off Ver
    2010, 2013 2016 Pro
    Posts
    85

    Site basic hours calculating wrong

    I am trying to set up a time sheet to work out site basic hours, these are between 07.00 and 18.00, the problem I have is with the summing up, basically my problem is indicated below:-

    If I work 06:00 to 17:00 this should be 10 hours site basic and 1 hour premium hours, but the below sum calculates the site basic hours to 11
    Or if I work 09:00 to 20:00 this should be 9 hours site basic and 2 hour premium hours, but the below sum calculates the site basic hours to 11

    =IF(AND(J36="",M36=""),"",(IF(AND(Table_Data!J1),"",IF(AND(J36<=7,M36>18),(18-7),M36-J36))))

    Site basic hours 07.00-18.00 Monday to Saturday. Premium rates 18.00-07.00 Monday to Saturday
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-13-2010
    Location
    Kozhikode, Keral, India
    MS-Off Ver
    Microsoft Office home and student 2019
    Posts
    49

    Re: Site basic hours calculating wrong

    Hi Roy,

    Please let us know that if the work is done during 07.00 and 18.00 how much should be the work hours
    1. 10 site basic + 1 premium OR
    2. 11 site basic ?
    I believe that 07.00 to 18.00 is the standard work timing.

  3. #3
    Registered User
    Join Date
    05-13-2010
    Location
    Kozhikode, Keral, India
    MS-Off Ver
    Microsoft Office home and student 2019
    Posts
    49

    Re: Site basic hours calculating wrong

    and what is the max site basic allowed work hours in a day?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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