Vlookup affecting an IF formula - multiple If Formula

[KJ2607]

Hi


I am using the following formula in IA7 to work out total hours between the end of one shift and the start of another:


=IF(ISBLANK(HW7),"",IF(IB7="","",MOD(IB7-HX7,1)))


This was working fine until I entered a Vlookup formula into HW7 which now enters 00.00 into the cell and therefore throws off the above formula -


Basically if HW7 = 00.00, then I want IA7 to remain blank, as soon as other values are entered, I need the calculation to work - any suggestion on how I can do this?


Thanks in Advance

 

[VoG]

Try

=IF(HW7=0,"",IF(IB7="","",MOD(IB7-HX7,1)))

 

[KJ2607]

Hi VoG - Thanks for your quick reply

That is what I tried initially and it failed but I must have added/deleted a comma or "" along the way as it works now - sometimes it just needs another pair of eyes - Thank you!