PDA

View Full Version : Formulas help



KK1966
08-03-2010, 07:07 PM
Hi anyone can help me if formulas can calculate by criteria to subtract the results.

Example

Cells A1 = found Col “C” if =”014 & Col “D”= Time, - Col “ C”=013 & Col “ D” time.


2:00 021 12:00
022 13:00
013 14:00
017 15:00
014 16:00
015 17:00
019 18:00
021 19:00
021 20:00
021 21:00
021 22:00

Bob Phillips
08-04-2010, 12:54 AM
Your explanation is not at all clear, nor is the example.

KK1966
08-04-2010, 01:26 AM
Attached example
please help

Bob Phillips
08-04-2010, 02:13 AM
The layout is better, the explanation is still as rubbish.

What are you trying to achieve?