Formula Assistance Needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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)

Syd said:
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
Click to expand...
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
Click to expand...
between (C8-C7) if either the value is 2880 or less to the value of (D71).
 
Back
Top