Date and Time Functions – N to Z
Table of Contents How to use the NETWORKDAYS function How to use the NETWORKDAYS.INTL function How to use the NOW […]

How to use the TIME function
What is the TIME function? The TIME function returns a decimal value between 0 (zero) representing 12:00:00 AM and 0.99988426 […]

How to AVERAGE time
Table of Contents How to AVERAGE time How to enter an array formula Explaining formula How to calculate the average […]

Time sheet for work
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]

Calculate time between time zones
This article demonstrates how to build a time zone chart and calculate times different than your time zone. The worksheet […]

Find empty hours in a weekly schedule
The image above demonstartes an array formula in cell B34 that extracts empty hours in a weekly calendar. I have created […]