lundi 16 septembre 2019

How to Calculate Time Between Two Dates with constraints taken into account (working hours)?

I'm trying to calculate the time between two dates BUT also whilst taking into account a working hour constraint. I am trying to do this using Excel formulas.

Example follows below, where the working hour constraint would be between 08:00 -> 18:00. I.e only time which follows during these hours should be taken into account.

+---------------+-------------+----------------------+----------------------+
|     Start     |     End     |  Total Difference    | Within Working Hours |
+---------------+-------------+----------------------+----------------------+
| 1/1/19 20:20  | 1/2/19 9:30 | 13 hours, 10 minutes | 1 hour, 30 minutes   |
+---------------+-------------+----------------------+----------------------+

The question is how do I calculate the Within Working Hours column?

Thanks!

Aucun commentaire:

Enregistrer un commentaire