Write a user-defined function that accepts time in hours as parameter and display it in minutes and seconds.
Answers
Answered by
0
Answer:
The TIME function is categorized under Excel DATE/TIME functions. TIME helps us to create a time with individual hour, minute, and second components.
While doing financial analysis, we might wish to put a time stamp on a report. In such scenarios, TIME can be used to convert a text string into a decimal format that represents the time. The function can also be used to merge individual values into a single time value.
Formula
=TIME(hour, minute
Similar questions