Forum Discussion

JoshuaCase's avatar
JoshuaCase
Qrew Cadet
3 years ago

Calculate Normal Hours and OT Hours

I need to calculate hours that are considered OT or Premium vs Standard Hours based on a end-user in and out time.

I am asking the end-user to enter their in and out time as part of the form.  If the in time is before 7 AM EST then those hours from the designated start to 7 AM would be Premium.  In the reverse any time worked past 5 PM would be premium.  

Example: 
In Time: 6 AM
Out Time: 6 PM

Regular Hours: 10
Premium Hours: 2

How do I make these calculations?

------------------------------
Joshua Case
------------------------------
Formulas and functions
  • JennWeber's avatar
    JennWeber
    Qrew Member
    3 years ago

    We use 7 AM and 6PM to calculate the Premium Hours:
    var timeofday start =[Start-1];
    var timeofday stop =[Stop-1];
    var date Mydate = [Date];
    var duration Hrs = $stop-$start;
    //Start before 7AM, If stop after 7AM time between start and 7AM, otherwise hrs
       var duration AM= If(Hour($Start)<7,If(Hour($Stop)>6.999,ToTimeOfDay("7 am")-$Start,$hrs),Hours(0));

    //Stop after 6PMS, if start before 6PM calculate time after 6PM, otherwise hrs
       var duration PM= If(Hour($Stop)>17.999, If(Hour($Start)<17.999,$Stop-ToTimeOfDay("6 pm"),$hrs),Hours(0));

    Sum($AM,$PM)
    IN a separate field, the regular hours would then be the total hours - the premium hours 



    ------------------------------
    Jenn Weber
    ------------------------------