SOLVED

formula help

Contributor

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.

 

Thanks for your time

4 Replies
best response confirmed by spalmer (Contributor)
Solution

@spalmer 

Thanks for posting a sample workbook. Try this formula:

 

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

@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.

@spalmer 

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.

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