How to Convert Time to Decimal in Google Sheets

In this video, I show how to convert a time to a decimal value in Google Sheets. There are a couple methods that you can use to do this. The first method uses a combination of the HOUR, MINUTE, and SECOND functions. The second method uses the TIMEVALUE function.

Read through the full tutorial here:
https://www.modernschoolbus.com/conve...

Timestamps:
00:00 Intro
00:40 HOUR, MINUTE, and SECOND Functions
2:05 Converting Time to Decimal with HOUR, MINUTE, and SECOND
4:02 TIMEVALUE Function
5:32 Converting Time to Decimal with TIMEVALUE

• #education
• #convert_time_to_decimal_google_sheets