Designing and testing clock based logic like flip-flops and counters is hard in EXCEL, but we have had some success in this project.
The initial value is 00, press switch 1, add 1 to the tens, press switch 2, add 1 to the units.
Our group worked on designing and implementing a Digital Timer Circuit.