I fail to formulate argument similar to: =IF(A13>=40,40,A13), but use hours instead of numbers, ie, IF A13 (say 44:25:00) is greater or equal to 40:00:0, then 40:00:00.
And another argument: IF A13 is greater than 40:00:00, then 44:25:00-40:00:00.
Can anyone help? Thanks.
Hi Itzhaky,
welcome to the forum.
This seems tricky but is really easy to resolve. Enter the time value as a text "44:00:00", wrap it in () braces and preceed it with the double unary --, like this
=IF(A13>=--("40:00:00"),--("40:00:00"),etc....)
The -- will coerce the text into a numeric value. Just format the result with custom format [hh]:mm:ss, as the other cells
hth
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks