Formula

[megha]

I have a formula on attached file that calculate employee "Time Out" with formula. It is working fine if the logic in cell is equal to the next line but it returns blank when logic is not eqaul to the next line. I want to have current line TmIN when logic is not eqals to. how can that be done? I have added more explanation on the attached file. I would appriciate any help.... Thank you in advance!

[surealdeals]

Hi I am quite new to this myself but I think you may need to simply replace the value if false towards the end to the in time instead of an empty string, as in the line as per your spreadsheet for example inserting

=IF(A35=A36,IF(E35=C36,D36-0.0004444444444444,D35),D35)

will give the time you request.

Regards
Ric

[Bob Phillips]

I think you could change it to

=IF(AND(A35=A36,E35=C36),D36-0.0004444444444444,D35)