TIME Function (Functions in Excel)
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. |
0 comments:
Post a Comment