Multiple choice technology web technology

Converts a time in the form of text to a serial number

  1. TIMEVALUES

  2. TIME

  3. STRINGTIME

  4. TIMEVALUE
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

TIMEVALUE converts a time stored as text into a serial number that Excel recognizes as a time. This is the time equivalent of DATEVALUE. Functions like TIMEVALUES and STRINGTIME don't exist in Excel. TIME itself constructs a time from numeric components.

Keep practicing — related questions