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