Forum Discussion
How to calculate Hours
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 https://www.extendoffice.com/documents/excel/3825-excel-calculate-net-work-hours-between-two-dates-excluding-weekends.html
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 |
|
The included sample file could help you in your project.
Hope I could help you with these information / file.
I know I don't know anything (Socrates)
1 Reply
The included sample file could help you in your project.
Hope I could help you with these information / file.
I know I don't know anything (Socrates)