June 13, 2013 at 5:46 am
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
duplicate post, reply to http://www.sqlservercentral.com/Forums/Topic1462994-391-1.aspx
June 13, 2013 at 6:10 am
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