ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Scheduling Hours (https://www.excelbanter.com/excel-programming/314893-scheduling-hours.html)

Trevor

Scheduling Hours
 
How do I check that our normal business hours are covered by our one or more
employees. i.e. 1.00pm - 2.00am is my Bar's business hours. If I have two
employees on any paticular day can I use excel to check that from 1pm to 2 am
that there is no gap in between.

Rob van Gelder[_4_]

Scheduling Hours
 
I have a formula on my website which covers this:
"Hours affected by dates"


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Trevor" wrote in message
...
How do I check that our normal business hours are covered by our one or
more
employees. i.e. 1.00pm - 2.00am is my Bar's business hours. If I have two
employees on any paticular day can I use excel to check that from 1pm to 2
am
that there is no gap in between.





All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com