Post reply

Total Sum is not Calculating in event of Multiple Clock events

  • November 5, 2016 at 5:19 am

    #1910758

    Hello Sgmugson,

    Thanks for your effort to provide quality answers where no matter how my question is good or bad:) .

    No remote workers taking part in this calculation. Secondly i had two solution (1 is either add additional column like shift time and etc further compute clock events. And 2 on is Chris solution which daypart method).

    OT will come negative since there employee who does not follow the dutyhours . For your information i am pretty sure that apart from one double post with same information i did not post anything else with same requirement. And i am sure that what ever i am posting for different result only but my query looks same but in the end the the result i am expecting is different.

    let us make pit and pieces further. you may shoot your questions and i will provide what every my real SCENARIO avails..

    BR

  • November 21, 2016 at 3:08 pm

    #1913875

    philand3 (11/1/2016)

    Hi,

    Data is given for also 10371 for which find below query results,

    You also appear to have an hours worked calculation gone wrong, as you might want to look at the fact that you have clock-in times that are later than clock-out times. Figure out how that happened and you will be in much better shape. I suspect that an ordering of those clock punches has not taken place correctly, and possibly due to the fact that you have separate date and time values, or possibly the UTC conversion threw the time value into a previous day, or possibly one value was converted to UTC and the other wasn't... It could be one of a dozen things.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply