Forum Discussion
Solved
Help with an IF function
Hi there,
Looking to write an IF function in cell J11 where if the value in cell J10 is equal to or greater than 08:00 then return 08:00.
J10 is the brought forward total from the previous periods flexi hours sheet, we are only allowed to carry forward 8 hours per period.
J10 is currently populated with a function, carrying hours forward from the previous sheet (='07.02.22-04.03.22'!T31), current value 10:15.
Tried this =IF(J10>=08:00,08:00,J10) and =IF(J10>=8,8,J10), but it's not working.
Any advice greatly appreciated so I can sort my flexi time out!
S
salba1705 Try it this way:
Excel stores times as fractions of 24 hours. Thus, 8 hours = 8/24 = 0.333333333.
salba1705 Try it this way:
Excel stores times as fractions of 24 hours. Thus, 8 hours = 8/24 = 0.333333333.
- Thank-you!
That has worked. Really appreciate you coming back to me.
