Learn formula for time calculation in excel

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.