Skip to main content

TIME

The TIME function returns the decimal number for a particular time.

Syntax​

=TIME(hour, minute, second)

Parameters​

  • hour: A number from 0 to 23 representing the hour
  • minute: A number from 0 to 59 representing the minutes
  • second: A number from 0 to 59 representing the seconds

Examples​

=TIME(12, 0, 0) // Returns 0.5 (noon)
=TIME(16, 30, 0) // Returns 0.6875 (4:30 PM)
=TIME(9, 15, 30) // Returns 0.385763889 (9:15:30 AM)