Post reply

how to caluculate half day

  • June 13, 2013 at 5:46 am

    #279113

    hi

    i want to caluclate half day

    my actual data is like this

    date-----------------------------eid---------------timein---------------------------timeout-----------spend-----excessshort------excess

    2013-03-21 00:00:00.000---26446---2013-06-13 09:13:00.000--2013-06-13 3:46:00.000----06:33:00---- 02:27:00-------Short

    i want this data

    date-----------------------------eid---------------timein---------------------timeout-----------spend-----excessshort-excess----Remarks

    2013-03-21 00:00:00.000--26446--2013-06-13 09:13:00.000--2013-06-13 3:46:00.000-06:33:00--02:27:00---Short------HALFDAY

    employee timing is 9am to 6pm if he leaves from factory at 4pm or before 4 pm then remarks say halfday

    becouse we have 2 hours half day mean if he go for some work and didnt come back for 2 hours our more then 2 hours then half day implemented

    please help me out

    thanks for the help

    immad

  • June 13, 2013 at 6:08 am

    #1623642

    duplicate post, reply to http://www.sqlservercentral.com/Forums/Topic1462994-391-1.aspx

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • June 13, 2013 at 6:10 am

    #1623644

    sir i dont know how its happen becouse i create only one post

    immad

Viewing 3 posts - 1 through 2 (of 2 total)

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