Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Let’s Talk 💬
  • Add-Ons

timevalue

TIMEVALUE Function – Google Sheets

October 11, 2023October 11, 2022 Adam Steinfurth

The TIMEVALUE function converts a time to a decimal value between 0 (inclusive) and 1 (exclusive). The function can convert time stored as a string or a number. Google Sheets works with times in formulas as fractions of a number, not as text strings. This function converts times into their usable form. For example, 12 … Read more

Categories Date parts Tags date, datedif, days, function, time, timevalue

TIME Function – Google Sheets

May 8, 2023October 6, 2022 Adam Steinfurth

The TIME function takes three numbers and converts them to time with hours, minutes, and seconds.

Categories Date parts Tags date, function, networkdays, networkdays.intl, time, timevalue, weekends
StaySorted moving a row automatically

Get the Google Sheets Add-On
  • Home
  • Subscriber Portal
  • Functions
  • About
  • Contact
© 2025 Sheets Help • Built with GeneratePress