TIME (Returns the serial number of a particular time)

What Does It Do?

This function will convert three separate numbers to an actual time.

Syntax

=TIME(Hour,Minute,Second)

Formatting

The result will be shown as a time which can be formatted either as 12 or 24 hour style.

If a normal number format is applied a decimal fraction is shown which represents the time as a fraction of the day.