Thread: IF Statement using errors

Can anyone help me with this IF Statement?

I am currently constructing a sheet to work out total hours from a “Time in” cell and a “Time out” cell. Now I need the If statement because if someone was to input an earlier time out than the time in then this would generate a negative figure which then replaces the total hours cell with “##########”

So far I had several combinations but this being just one example:

=IF(G11-F11="ISERROR","CHECK TIME",G11-F11)

I’ve broken down below what the cells represent

=IF(TIME IN–TIME OUT= the error ####, “CHECK TIME”, TIME IN – TIME OUT)

I tried various symbols and words to represent the #### error. I could not find anything similar on the net.

Basically If the negative error appears because of incorrect times being imputed I want the cell to say “Check Time” so to notify the user. Obviously if there is no error then I just want the original total hour calculation.

Thanks

Thanks for the speedy reply, but unfortunately I have already tried these combinations