Hours In Zone

Email:     support@tvmap.com Phone:   +64 9 304 0762

<< Click to Display Table of Contents >> Navigation:  TVmap > TVmap in Excel > TVmap Functions > Hours In Zone Email:     support@tvmap.com Phone:   +64 9 304 0762

 

HoursInZone calculates the total number of hours in a zone specified by parameters

 

The HoursInZone function requires the following parameters:

FromDate

ToDate

FromTime

ToTime

DayMask [Optional]

 

Example

Below is an example of the HoursInZone function showing the HoursInZone for week commencing 30/06/2019, peak time and including all days of the week.

 

 

 

---

 

* Excel® is a registered trademark of Microsoft Corporation