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.
[VBA]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[/VBA]
Your explanation is not at all clear, nor is the example.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Attached example
please help
The layout is better, the explanation is still as rubbish.
What are you trying to achieve?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
