TIME ()
This
function will convert three separate numbers to an actual time.
Best view in desktop mode.
A
|
B
|
C
|
D
|
E
|
F
|
|
1
|
Hour
|
Minute
|
Second
|
Time
|
||
2
|
14
|
30
|
59
|
14:30:59
|
=TIMC(A2,B2,C2)
|
|
3
|
14
|
30
|
59
|
2:30:59 PM
|
=TIMC(A3,B3,C3)
|
|
4
|
14
|
30
|
59
|
0.60485
|
=TIMC(A4,B4,C4)
|
|
5
|
||||||
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.
Shortcut Key for Formatting
Go to D2 cell, Press Ctrl+1, and you will see new pop-up window like below:
In the left side
section, select time and right side section select the time format you want to
see in excel and click OK button.
No comments:
Post a Comment