TIME

Posted on 22-01-2020 , by: admin , in , 0 Comments

time

Hour Minute Second Time
14 30 59 14:30:59  =TIME(C4,D4,E4)
14 30 59 2:30:59 PM  =TIME(C5,D5,E5)
14 30 59 0.60485  =TIME(C6,D6,E6)

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.

Leave a comment