IFS(
HOUR([Total Hours]) >= 8,“08:00:00”,
TRUE,[Total Hours]
)
I get this error on the above formula
“IFS function is used incorrectly:Inputs to IFS() must be condition-value pairs. Input 4 is not a value of a consistent type.”
IFS(
HOUR([Total Hours]) >= 8,“08:00:00”,
TRUE,[Total Hours]
)
I get this error on the above formula
“IFS function is used incorrectly:Inputs to IFS() must be condition-value pairs. Input 4 is not a value of a consistent type.”
It sounds that [Total Hours] is a duration and “08:00:00” is a time.