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 |
---|---|
26 | |
25 | |
23 | |
22 | |
20 |