Excel tutorials

We can use Excel to a lot of things – one way is to use it as a timer

Lets create a simple countdown timer.

In column A we set the date – the other columns are going to show us how long it is until our set date.

For this we are going to use four different functions

• INT
• HOUR
• MINUTE
• SECONDS

In column B cell B2 enter the following formula:

=INT(A2-NOW())

This just subtracts the date in A2 from todays date.

In cell C2 enter the following foruma:

=HOUR(A2-NOW())

In cell D2 enter the followin formula:

=MINUTE(A2-NOW())

And finally to get the seconds, enter the following formula in E2:

=SECOND(A2-NOW())

This will not refresh automatically, if you hit F9 you can see that the values are changing.

The best way here is to write a small macro and run this every second to make it look like a timer.