I need help please,
How can I calculate business hours between two dates?
For example we have two dates;
01/01/2017 10:00 and 04/01/2017 15:00.
And we have working hours 09:30 to 17:30 (8 hours) on weekdays. How can I calculate working hours and minutes with Java?
Thanks for your help.
解决方案
everyone! I faced similar problem (calculate working minutes between to TimeStamps) and finished with this solution. Hope, somebody finds it's useful:
public class WorkingMinutesCalculator {
private static final int WORK_HOUR_START = 9;
private static final int WORK_HOUR_END = 17;
private static final long MINUTES = 60;
private static final long WORKING_HOURS_PER_DAY = WORK_HOUR_END - WORK_HOUR_START;
private static final long WORKING_MINUTES_PER_DAY = WORKING_HOURS_PER_DAY * MINUTES;
public int getWorkingMinutesSince(final Timestamp startTime) {
Timestamp now = Timestamp.from(Instant.now());
return getWorkingMinutes(startTime, now);
}
public int getWorkingMinutes(final Timestamp startTime, final Timestamp endTime) {
if (null == startTime || null == endTime) {
throw new IllegalStateException();
}
if (endTime.before(startTime)) {
return 0;
}
LocalDateTime from = startTime.toLocalDateTime();
LocalDateTime to = endTime.toLocalDateTime();
LocalDate fromDay = from.toLocalDate();
LocalDate toDay = to.toLocalDate();
int allDaysBetween = (int) (ChronoUnit.DAYS.between(fromDay, toDay) + 1);
long allWorkingMinutes = IntStream.range(0, allDaysBetween)
.filter(i -> isWorkingDay(from.plusDays(i)))
.count() * WORKING_MINUTES_PER_DAY ;
// from - working_day_from_start
long tailRedundantMinutes = 0;
if (isWorkingDay(from)) {
if (isWorkingHours(from)) {
tailRedundantMinutes = Duration.between(fromDay.atTime(WORK_HOUR_START, 0), from).toMinutes();
} else if (from.getHour() > WORK_HOUR_START) {
tailRedundantMinutes = WORKING_MINUTES_PER_DAY;
}
}
// working_day_end - to
long headRedundanMinutes = 0;
if (isWorkingDay(to)) {
if (isWorkingHours(to)) {
headRedundanMinutes = Duration.between(to, toDay.atTime(WORK_HOUR_END, 0)).toMinutes();
} else if (from.getHour() < WORK_HOUR_START) {
headRedundanMinutes = WORKING_MINUTES_PER_DAY;
}
}
return (int) (allWorkingMinutes - tailRedundantMinutes - headRedundanMinutes);
}
private boolean isWorkingDay(final LocalDateTime time) {
return time.getDayOfWeek().getValue() < DayOfWeek.SATURDAY.getValue();
}
private boolean isWorkingHours(final LocalDateTime time) {
int hour = time.getHour();
return WORK_HOUR_START <= hour && hour <= WORK_HOUR_END;
}
}