## TIME Function – Google Sheets

The TIME function takes three numbers and converts them to a time. The hour is input as 0-24 and therefore therefore you don’t need to enter AM/PM.

## Syntax

`=TIME(hour,minute,second)`

`hour` Number that represents the hour (0-23).

`minute` Number that represents the minute (0-59).

`second` Number that represents the second (0-59).

## Related functions

DATE – In a similar way to the TIME function, DATE takes three numbers and converts them to a date.

## Errors

#VALUE! – The inputs are something that isn’t a valid time such as “The other day” or “Yester-yester-day”.

## Examples

### Live examples in Sheets

Go to this spreadsheet for the examples of the TIME function shown above that you can study and use anywhere you would like.

## NETWORKDAYS Function – Google Sheets

The NETWORKDAYS function calculates the number of working days between two dates. The function excludes weekends (Saturday and Sunday) and can exclude holidays if you provide a list.

## Syntax

`=NETWORKDAYS(start_date,end_date,[holiday(s)])`

`start_date` Date at which to start the calculation

`end_date` Date at which to end the calculation

`[holiday(s)]` An optional list of holidays to exclude from the count of days.

## Related functions

DAYS – Calculate the number of days between two dates.

DATEDIF – Calculate length of time between two dates in years, months, and/or days.

MINUS – Subtract one value from another. Can be done with dates.

NETWORKDAYS.INTL – Calculate the number of work days between two dates. You can modify which days are weekends.

## Errors

#VALUE! – The inputs are something that isn’t a valid date such as “The other day” or “Yester-yester-day”.

## Examples

### Live examples in Sheets

Go to this spreadsheet for the examples of the NETWORKDAYS function shown above that you can study and use anywhere you would like.