nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Labor Hours between 2 dates.

csasaki

Hi I need to calculate the labor hours between 2 dates.
For example :
Labor Schedule : 8:00 AM - 5:00 PM Monday to Friday

Monday 2 January 2012 - 1:00 PM
Monday 9 January 2012 - 2:00 PM
Labor Hours between dates : 41 Hours

Or

Monday 2 January 2012 - 2:00 PM
Tuesday 3 January 2012 - 9:00 AM
Labor Hours between dates : 4 Hours.

I have the 2 dates (timestamp) and need the hours between them.
Any idea?

Find more posts tagged with

Comments

csasaki

Well
I finally got a logic for this.

1) Get the labor days between the 2 dates. (Checked)
2) Subtract 2 days to the labor days. (Checked)
3) Multiply the labor days left for 8hours a day. (Checked)

4) Get the hour of the first date and use the BirtDateTimeDiffMinute function to get the minutes between the first date hour and 5pm.

5) Get the hour of the last date and use the BirtDateTimediffMinute function to get the minutes between the last date hour and 8AM.

mwilliams

So, problem solved?

csasaki

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="93812" data-time="1326127649" data-date="09 January 2012 - 09:47 AM">
So, problem solved? </blockquote>
 
Hi Michael 
 
I could not get the report done. 
But Again I would like to calculate the labor hours between 2 dates. Also not including the Weekends days. Do you have any logic I could use? 
 
I was thinking on calculate the weeks between the 2 dates. Then multiply those week_numbers * 2 to get the Weekends. But not sure.

lgudait

I came up with a solution that makes the following assumptions:

- Start & End dates are always weekdays within working hours
- Workdays are always 8 hours, starting at 9:00 AM
- No consideration is given to breaks/lunches, nor company holidays

I designed the solution using 2 parameters (StartDate & EndDate) - substitute whatever your fields are for the parameters

+BirtDateTime.diffDay(params["StartDate"].value,params["EndDate"].value)*8
-(BirtDateTime.week(params["EndDate"].value)-BirtDateTime.week(params["StartDate"].value))*16
-(params["StartDate"].value.getHours()-9)
+(params["EndDate"].value.getHours()-9)

Line 1 calculates the total potential work hours between the start & end date
Line 2 removes any hours that fall over the weekend.
Line 3 accounts for any start times after 9 AM on the first day
Line 4 adds in any hours on the last day

lgudait

One more restriction that I didn't realize when I posted - Line 2 assumes that it is the same year. I made a small modification that accounts for multiple years:

+BirtDateTime.diffDay(params["StartDate"].value,params["EndDate"].value)*8
-(BirtDateTime.diffWeek(params["StartDate"].value,params["EndDate"].value))*16
-(params["StartDate"].value.getHours()-9)
+(params["EndDate"].value.getHours()-9)

csasaki

<blockquote class='ipsBlockquote' data-author="'lgudait'" data-cid="109461" data-time="1347915384" data-date="17 September 2012 - 01:56 PM">
One more restriction that I didn't realize when I posted - Line 2 assumes that it is the same year. I made a small modification that accounts for multiple years: 
 
+BirtDateTime.diffDay(params["StartDate"].value,params["EndDate"].value)*8 
-(BirtDateTime.diffWeek(params["StartDate"].value,params["EndDate"].value))*16 
-(params["StartDate"].value.getHours()-9) 
+(params["EndDate"].value.getHours()-9) </blockquote>
 
Hi 
 
Thanks for your reply. What you did was very simple and good!hat will you add to your code to get the minutes also? 
 
 
My code is to large : 
 
 
var weeks = BirtDateTime.diffWeek(params["Date1 1"].value,params["Fecha 2"].value); 
var days = BirtDateTime.diffDay(params["Date2 1"].value,params["Fecha 2"].value); 
var days_completes = (days - weeks*2 - 1); 
 
var Fecha_param_1 = params["Date1 1"].value; 
var Fecha_param_2 = params["Date2 2"].value; 
if (Fecha_param_2== null) 
{ 
Fecha_param_2 =BirtDateTime.now(); 
} 
if (dias_completos >= 0) 
{ 
var Year1= BirtDateTime.year(params["Fecha 1"].value); 
var Mes1 =BirtDateTime.month(params["Fecha 1"].value); 
var day1 = BirtDateTime.day(params["Fecha 1"].value); 
var fecha1 = Year1 + "-" + Mes1 + "-" + day1 +" 18:00:00" ; 
var minutos_dia1 = BirtDateTime.diffMinute(params["Fecha 1"].value,fecha1); 
 
var Year2= BirtDateTime.year(Fecha_param_2); 
var Mes2 =BirtDateTime.month(Fecha_param_2); 
var day2 = BirtDateTime.day(Fecha_param_2); 
var fecha2 = Year2 + "-" + Mes2 + "-" + day2 +" 09:00:00" ; 
var minutos_dia2 = BirtDateTime.diffMinute(fecha2,Fecha_param_2); 
 
 
 
var minutos_total = dias_completos*60*9 + minutos_dia1 + minutos_dia2; 
 
 
var horas_total; 
horas_total = BirtMath.round(minutos_total/60,0); 
if (horas_total < 1) 
{ 
horas_total = 0; 
} 
 
var sobrante = BirtMath.mod(minutos_total,60); 
 
if (sobrante>=10) 
{ 
var output = horas_total + ":" + sobrante; 
} 
else 
{ 
var output = horas_total +":0" +sobrante; 
} 
output; 
 
} 
 
if (dias_completos == -1) 
{ 
 
var minutos_total=BirtDateTime.diffMinute(params["Fecha 1"].value,Fecha_param_2); 
 
var horas_total; 
horas_total = BirtMath.round(minutos_total/60,0); 
if (horas_total < 1) 
{ 
horas_total = 0; 
} 
var sobrante = BirtMath.mod(minutos_total,60); 
 
if (sobrante>=10) 
{ 
var output = horas_total + ":" + sobrante; 
} 
else 
{ 
var output = horas_total +":0" +sobrante; 
} 
output; 
 
}

Panky

Igudait, that works perfectly thanks. A sweet and simple solution 
 
 
<blockquote class='ipsBlockquote' data-author="'csasaki'" data-cid="109469" data-time="1347917693" data-date="17 September 2012 - 02:34 PM">
Hi 
 
Thanks for your reply. What you did was very simple and good!hat will you add to your code to get the minutes also? 
 
 
My code is to large : 
 
 
var weeks = BirtDateTime.diffWeek(params["Date1 1"].value,params["Fecha 2"].value); 
var days = BirtDateTime.diffDay(params["Date2 1"].value,params["Fecha 2"].value); 
var days_completes = (days - weeks*2 - 1); 
 
var Fecha_param_1 = params["Date1 1"].value; 
var Fecha_param_2 = params["Date2 2"].value; 
if (Fecha_param_2== null) 
{ 
Fecha_param_2 =BirtDateTime.now(); 
} 
if (dias_completos >= 0) 
{ 
var Year1= BirtDateTime.year(params["Fecha 1"].value); 
var Mes1 =BirtDateTime.month(params["Fecha 1"].value); 
var day1 = BirtDateTime.day(params["Fecha 1"].value); 
var fecha1 = Year1 + "-" + Mes1 + "-" + day1 +" 18:00:00" ; 
var minutos_dia1 = BirtDateTime.diffMinute(params["Fecha 1"].value,fecha1); 
 
var Year2= BirtDateTime.year(Fecha_param_2); 
var Mes2 =BirtDateTime.month(Fecha_param_2); 
var day2 = BirtDateTime.day(Fecha_param_2); 
var fecha2 = Year2 + "-" + Mes2 + "-" + day2 +" 09:00:00" ; 
var minutos_dia2 = BirtDateTime.diffMinute(fecha2,Fecha_param_2); 
 
 
 
var minutos_total = dias_completos*60*9 + minutos_dia1 + minutos_dia2; 
 
 
var horas_total; 
horas_total = BirtMath.round(minutos_total/60,0); 
if (horas_total < 1) 
{ 
horas_total = 0; 
} 
 
var sobrante = BirtMath.mod(minutos_total,60); 
 
if (sobrante>=10) 
{ 
var output = horas_total + ":" + sobrante; 
} 
else 
{ 
var output = horas_total +":0" +sobrante; 
} 
output; 
 
} 
 
if (dias_completos == -1) 
{ 
 
var minutos_total=BirtDateTime.diffMinute(params["Fecha 1"].value,Fecha_param_2); 
 
var horas_total; 
horas_total = BirtMath.round(minutos_total/60,0); 
if (horas_total < 1) 
{ 
horas_total = 0; 
} 
var sobrante = BirtMath.mod(minutos_total,60); 
 
if (sobrante>=10) 
{ 
var output = horas_total + ":" + sobrante; 
} 
else 
{ 
var output = horas_total +":0" +sobrante; 
} 
output; 
 
} </blockquote>