Countdown Clock Formula?

[thelostscott]

Hi all,

I'm wanting to set-up a Clockdown clock formula to show how many working hours are left between 20/05/2011 17:00:00 and =NOW().

Any ideas of how to go about this?

If I have a working day start-time of 08:30:00 and a finish time of 17:00:00 I can work that out just for today however it won't change the hours remaining just by changing the date?

Many thanks!

 

[GlennUK]

That'd just be the number of working hours for today, plus (17:00-8:30) times the number of working days up to 20/05/2011. Like:

=((TODAY()+"17:00")-NOW())+("17:00"-"08:30")*(NETWORKDAYS(TODAY(),DATE(2011,5,20),Holidays)-1)

... asssuming that you a named range for holidays, if you need it ( otherwise remove that ).

By the way, NETWORKDAYS is part of the Analysis Toolpak, which you may need to Add-In ( not so, in 2007 though ).

 

[thelostscott]

Perfect! Works a treat, thanks for that!