Forum Discussion

Ashfaq's avatar
Ashfaq
Regular Visitor
7 years ago
Solved

Calculate Hours Late for Employee

Hello Experts,   I do have below data sets in my Source Database table. The standard in and out times of employees are from 08:00 A.M till 02:00 P.M.   Emp Date Ref_IN_Time IN_Time Ref_OU...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    I would do this in 3 columns:

     

    Column = DATEDIFF([Ref_IN_Time],[IN_Time],MINUTE)+DATEDIFF([OUT_Time],[Ref_OUT_Time],MINUTE)


Status = IF([Column]=0,"On Time","Late")


Late = 
VAR __hours = INT([Column]/60)
VAR __minutes = [Column] - 60*__hours
RETURN CONCATENATE(CONCATENATE(__hours,":"),__minutes)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

I would do this in 3 columns:

 

Column = DATEDIFF([Ref_IN_Time],[IN_Time],MINUTE)+DATEDIFF([OUT_Time],[Ref_OUT_Time],MINUTE)


Status = IF([Column]=0,"On Time","Late")


Late = 
VAR __hours = INT([Column]/60)
VAR __minutes = [Column] - 60*__hours
RETURN CONCATENATE(CONCATENATE(__hours,":"),__minutes)
  • Ashfaq's avatar
    Ashfaq
    Regular Visitor
    7 years ago

    Thank you Greg_Deckler, It worked like a charm,

     

    I do have one more question, But i will open another post for that.

     

    Regards

    ASHFAQ