Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to caluculate half day Expand / Collapse
Author
Message
Posted Thursday, June 13, 2013 5:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:11 AM
Points: 105, Visits: 323

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
Post #1462991
Posted Thursday, June 13, 2013 6:08 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:55 AM
Points: 2,477, Visits: 3,014
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’! **
Post #1463003
Posted Thursday, June 13, 2013 6:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:11 AM
Points: 105, Visits: 323
sir i dont know how its happen becouse i create only one post
Post #1463005
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse