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?
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?