TIMEVALUE Function

From Planfix
Jump to: navigation, search

This function takes a time represented as a string and returns a decimal value. The value of time is a decimal number in the interval from 0 to 0.99988426, which represents the time from 0:00:00 to 23:59:59.

Format:

*TIMEVALUE(time_as_string)

Examples

IF(TIMEVALUE({{System.Current time}})>TIMEVALUE("10:30:00"); {{System.Today::FormatingDate=dd.MM.yyyy}}; {{System.Today::FormatingDateу=dd.MM.yyyy}}-1)


Go To