Countdown Timer

[Danbrighton]

Hello girls and Boy

Ive heard a rumour that you can set up a 'Countdown Timer' on excel i.e Days, hours, minutes and seconds to a particular day/event ..is this true and if it is how do you do it?

Dan

 

[Joe Was]

I have this string set to count-down my time left at work until quiting time: which is 6:30.

=ABS(DAY(NOW())) & "th Day: " & 7 - ABS(HOUR(NOW())-24) & "hrs " & 30 - ABS(MINUTE(NOW())-60) & "mins -" & ABS(SECOND(NOW())-60) & "secs, until quiting time!"