Sum and If function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark.M.Sweeney@gmail.com - 06 Jul 2007 12:12 GMT

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

Reply to this Message

Dave Peterson - 06 Jul 2007 12:27 GMT

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.

> 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
[quoted text clipped - 3 lines]
>
> Thanks, Mark

Signature

Dave Peterson

Reply to this Message

Roger Govier - 06 Jul 2007 12:31 GMT

Hi Mark

One way
=IF((B1-A1)*24>7,B1-A1-TIME(0,30,0),B1-A1)

Signature

Regards

Roger Govier

>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
[quoted text clipped - 3 lines]
>
> Thanks, Mark

Reply to this Message