IF Statement using errors

[Need For Excel]

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

[tigertiger]

Plz test the formula
=IF(iserror(G11-F11),"CHECK TIME",G11-F11)

Or
=IF(G11-F11<0,"CHECK TIME",G11-F11)

I am confusing to understand your explaitation, so giving two options that you can get

[ChemistB]

Try

=IF(ISERROR(G11-F11),"CHECK TIME",G11-F11)
Does that work?

[Need For Excel]

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

[ChemistB]

Then your problem is elsewhere. Can you upload a spreadsheet with a simple example in it (Go Advanced>Manage attachments)?