Syntax
=TIME(hour, minute, second)Arguments
| Argument | Required | Description |
|---|---|---|
hour | Required | The hour (values past 23 wrap around) |
minute | Required | The minutes (values past 59 carry into hours) |
second | Required | The seconds (values past 59 carry into minutes) |
How to use TIME
TIME takes 3 required arguments. Type =TIME( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=TIME(12, 0, 0)Result =TIME(18, 0, 0)Result =TIME(27, 0, 0)Result Related date and time functions
- NETWORKDAYSCounts the working days (Monday to Friday) between two dates, both included, leaving out holidays.
- NETWORKDAYS.INTLCounts the working days between two dates, both included, with a choice of weekend days and holidays.
- NOWReturns the current date and time.
- SECONDReturns the second (0 to 59) of a time.
- TIMEVALUEConverts a time written as text into a fraction of a day.
- TODAYReturns the current date.
- WEEKDAYReturns the day of the week of a date as a number (by default 1 for Sunday to 7 for Saturday).
- WEEKNUMReturns the week number of a date in its year (the week containing January 1 is week 1).
- WORKDAYReturns the date a number of working days (Monday to Friday) before or after a date, skipping holidays.