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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,224,544
Messages
6,179,430
Members
452,915
Latest member
hannnahheileen

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
Back
Top