TIME

The TIME function converts separate number values for hours, minutes, and seconds into a date/time value.

TIME(hours, minutes, seconds)

hours: The number of hours to include in the date/time value returned.

minutes: The number of minutes to include in the date/time value returned.

seconds: The number of seconds to include in the date/time value returned.

Notes

  • You can specify hour, minute, and second values greater than 24, 60, and 60, respectively. If the hours, minutes, and seconds add up to more than 24 hours, 24 hours are repeatedly subtracted until the value is less than 24 hours.

  • Any decimal portion in the hour, minute, and second values is ignored.

Examples

=TIME(12,0,0) returns 12:00 pm.

=TIME(16,45,30) returns 4:45 pm.

=TIME(0,900,0) returns 3:00 pm.

=TIME(60,0,0) returns 12:00 pm.

=TIME(4.25,0,0) returns 4:00 am.

See alsoDATEDATEVALUETIMEVALUE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Noderīgs?
Rakstzīmju ierobežojums: 250
Maksimālais ierobežojums ir 250 rakstzīmes.
Pateicamies par atsauksmēm!
Morty Proxy This is a proxified and sanitized view of the page, visit original site.