Sum and If function

  • Thread starter Thread starter Mark.M.Sweeney
  • Start date Start date
M

Mark.M.Sweeney

I have a simple sum that calculates the difference in between the
start time and end time. But, what I don't know how to do is put in
an If statement that says If the difference is greater than 7,
subract :30. Now, if I havr to do this as decimals, that is fine but
I was hoping to be able to keep it in a time format.

Thanks, Mark
 
I don't know if 7 is 7 days, 7 hours, 7 minutes, 7 seconds or what.

And is :30, 30 minutes or 30 seconds?

But in general:

=yourformula - if(yourformula>time(0,7,0),time(0,0,30),0)

Adjust those time(h,m,s) arguments the way you need.

And format the cell as time.
 
Back
Top