I'm trying to work out how many peak & non peak hours there are between two dates.
For example
Start Date : 07/12 @22:00
End Date : 08/12 @22:00
Peak Time = 00:30 - 07:30
Non Peak = 07:30 - 00:30
So between the date specified ( can start at any time ):
17 hours Peak
7 hours Non Peak
Hope you can help. Sample Attached.
HoursCalculator.xls
Thanks,
Bookmarks