If cell A5 displays a time in hours, minutes, and seconds, which of the following functions can you use to display the time as a serial number?
A) HOUR
B) TIME
C) SERIAL
D) NOW

Question

Quizplus · Accepted Answer

The TIME function is used to convert a time to a serial number in Excel. The HOUR function only returns the hour from a time value, the SERIAL function does not exist in Excel, and the NOW function returns the current date and time, not a serial number corresponding to a specific time.

If Cell A5 Displays a Time in Hours, Minutes, and Seconds