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 ...
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.
That has worked. Really appreciate you coming back to me.