java 工作时间,在Java中仅计算两个日期之间的工作时间（不包括周末）

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;

}

}