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.”
Solved! Go to Solution.
It sounds that [Total Hours] is a duration and “08:00:00” is a time.
It sounds that [Total Hours] is a duration and “08:00:00” is a time.
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
16 |