Sheila wants to extract the hour from the time,12:00:56,in cell A1.Which formula can she use to do this?
A) HOUR(A1)
B) =HOUR(A1)
C) =HOUR("12:00:56")
D) HOUR("12:00:56")

Question

Quizplus · Accepted Answer

The formula =HOUR(A1) will extract the hour from the time in cell A1. Option A is close, but it is missing the equal sign (=) needed to create a formula. Options C and D are incorrect because they are trying to use the HOUR function on a string of text instead of a cell reference.

Sheila Wants to Extract the Hour from the Time,12:00:56,in Cell