 SOLVED

Highlighted

# formula help

Need some help with a formula.  As I enter in my beginning time of 8:00 my total automatically enters 16:00 without entering anything in my end time.   What formula / function do i need to wait for my total to add up after i enter in my end time?

I have a formula in there now so if anyone can adjust that for me that would be great.  i also attached an example so you can better see what im talking about.

4 Replies
Highlighted
Best Response confirmed by spalmer (Contributor)
Solution

# Re: formula help

Thanks for posting a sample workbook. Try this formula:

=IF(OR(I6="",L6=""),"",MOD(L6-I6,1))

Highlighted

# Re: formula help

@Hans Vogelaar thank you very much Hans.  it worked.  if you can and if you have time could you explain that formula so i can learn from it?  if not no big deal, i appreciate your time already.

Highlighted

# Re: formula help

OR(I6="",L6="") is TRUE if either I6 or L6 is empty (or both are). So the formula

=IF(OR(I6="",L6=""),"",MOD(L6-I6,1))

returns a blank if either cell is blank. If both cells are filled, it returns MOD(L6-I6,1).

This is the difference of L6 and I6 (i.e. hours worked), but if L3 is smaller than I6, it adds 1.

Highlighted

# Re: formula help

@hans Thank you very much.  wasn't sure what MOD did.