Excel Function
TIME
Builds a time from hour, minute, second.
TIME(hour, minute, second)Arguments
hour
RequiredEnter a numeric value.
minute
RequiredEnter a numeric value.
second
RequiredEnter a numeric value.
Practice Preview
calculate and display date/time values. Use TIME to Builds a time from hour, minute, second. use 9 for hour, use 30 for minute, use 0 for second. Fill the argument fields below and complete a formula that achieves this goal.
Sample correct formula
=TIME(9, 30, 0)