Is there a way of creating a bar which moves along with the time?

zilch4ry

Board Regular
Joined
Feb 27, 2011
Messages
76
hi all,

I've been creating a spreadsheet for an ict task which states that the business i am producing the spreadsheet for "is open for sixteen hours a day and is staffed by two separate eight hour shifts." "the model should take account of relevant legislation covering the amount of breaks staff members are entitled to take during each eight hour shift."

What i would really like to do is produce some sort of bar that runs in time with the current time on my laptop and when it reaches hour "14:00" it then says something like "staff shift change" and also i would like to do the same for times "12:00" and "20:00" except these will say "staff 20 minute break"

if anyone can guide me with this it will be very appreciated as i have no idea where to start.




Thanks,


Tom



Something like this maybe?

tinypic.com
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

zilch4ry

Board Regular
Joined
Feb 27, 2011
Messages
76
Thanks for the suggestion, but i was hoping for something more along the lines of a shape- i dont think it can be done though.
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
You could do it using a modeless userform but is the effort worth it?
 

zilch4ry

Board Regular
Joined
Feb 27, 2011
Messages
76
i don't even know what that is but im willing to give it a go, thanks for the help - on second thought if you think it takes a lot of effort i think there is no point me even attempting such a thing ;) im a bit useless with macros
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,651
Messages
5,838,579
Members
430,557
Latest member
MK15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top