TIME

Create a time with hours, minutes, and seconds

Sponsored Link

TIME

Purpose 

Create a time with hours, minutes, and seconds

Return value 

A decimal number representing a particular time in Excel.

Syntax 

=TIME (hour, minute, second)

Arguments 

  • hour - The hour for the time you wish to create.
  • minute - The minute for the time you wish to create.
  • second - The second for the time you wish to create.

Usage notes 

The TIME function creates a date in serial number format from the hour, minute, and secondcomponents you specify. Use it to create a valid time when you have (or can supply) these component values separately. Once you have a valid time, you can format it any way you like.

Sponsored Link

0 votes. 0 / 5