I am looking for an excel formula that calculates time.
I want to enter from date and time to date and time and get out how many hours there are. I have tried using the from the link but it doesnt seems to work How To Calculate Net Work Hours Between Two Dates Excluding Weekends Or Holidays In Excel?
All these dates, will be edited next year and so on, its not always the same dates but yeah time is same,
Any help will be appreciated
| From | To |
| 15/02/2022 00:00:00 | 18/06/2022 00:00:00 |
| Weekdays 18:00 - 06:00 | |
| Weekends 06:00 - 18:00 | |
Weekends 18:00 - 06:00
(Towards Night To Saturday,
Sunday & Monday) | |
From 1 January, 06:00
To
21st January 06:00 | |
From 14 April, 18:00
To
19 April 06:00 | |
From 4 June 06:00
To
6 June 06:00 | |
From 25 June December 06:00
To
28 December 06:00 | |
From 31 December 06:00
To
1 January 06:00 | |
From 23 June 06:00
To
25 June 06:00 | |
From 24 December 06:00
To
25 December 06:00 | |
