Hayley is taking part in a reading competition at her local library. She has read for 22 hours and 15 minutes this quarter. When she enters her results in the shared Google Sheets document, what function should she use to convert her results to the format 22:15:00?

Question

(1 point)

Time()

Sum()

Max()

Count()

Answer 1

To convert her results to the format 22:15:00 in Google Sheets, Hayley should use the Time() function. This function is used to create a time value from hour, minute, and second components.

So, she would input it as follows:

=TIME(22, 15, 0)

This would give her the desired format of 22:15:00.

Correct answer: Time()