Product Announcements

Product Announcements

News on the latest product releases from the hottest new features to highly anticipated Smartsheet integrations can be found here! "Follow" to get notified of updates.


New! TIME function for formulas

Employee
edited 10/09/23 in Product Announcements

Hey Community,

Some of you may have noticed a new function in our Functions List last week…

Introducing the TIME Function!

This returns the time of day in 12- or 24-hour format from a given set of values.

Syntax

TIME(time_value, [ format ], [ precision ])

  • time_value — The value to create time with. Must be provided as a string or numbers representing hours, minutes, and seconds.
  • format —[optional] Specifies whether the time is displayed using a 12-hour (0) or 24-hour (1) clock.
  • precision —[optional] Requires format to be set first. Specifies the interval of time to return in either hh (1), hh:mm (2), or hh:mm:ss (3).

Example

Please see the function article for more detail and examples of how to use it effectively, and feel free to post your own solutions using TIME() in the comments below.

Cheers,

Genevieve

Need more information? 👀 | Help and Learning Center

こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

Comments

Recent Announcements