Formula Assistance Needed

[Guest]

Period Start (A5) 12/1/03 7:0
Job Start (A6) 12/1/03 9:0
Job End (A7) 12/24/03 6:5
Period End (A8) 1/1/04 6:5

SumOfColumn (D71) 12

Current Time (F2) =D71+((C8-C7)*24*60

What I want to do for Current Time cell (F2) is if the time difference between C8 and C7 is equal to or less than 2880 add that value to the value of cell (D71). If the difference between (C8) and (C7) is greater than 2880, do not add that value to the value in (D71), only show the value of (D71)

If the difference between (C8) and (C7) is greater than 2880,
do not add that value to the value in (D71), only add the difference between (C8-C7) if either the value is 2880 or less to the value of (D71).

Hope this helps explain what I'm looking for

Thanks, again!

 

[Bob Phillips]

Syd,

Is this what you want

=D71+(((C8-C7)*24*60)<=2880)*(C8-C7)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Period Start (A5) 12/1/03 7:00
Job Start (A6) 12/1/03 9:00
Job End (A7) 12/24/03 6:59
Period End (A8) 1/1/04 6:59

SumOfColumn (D71) 123

Current Time (F2) =D71+((C8-C7)*24*60)

What I want to do for Current Time cell (F2) is if the time difference

between C8 and C7 is equal to or less than 2880 add that value to the value
of cell (D71). If the difference between (C8) and (C7) is greater than 2880,
do not add that value to the value in (D71), only show the value of (D71).

If the difference between (C8) and (C7) is greater than 2880,
do not add that value to the value in (D71), only add the difference

between (C8-C7) if either the value is 2880 or less to the value of (D71).