I've put together a example database to show how I've implemented a visual representation of shop opening hours for a few dummy records.
The eventual solution will be for several hundred shops with possible different opening hours for each day of the week Monday through Sunday (7 days) with a minimum resolution that could be 5 mins i.e. 12 possible options per hour and two options per shop. That will work out to be alot of fields and calculations!
I tried looking at charting options in fmp but nothing seemed to fit the bill?
Can anyone think of a better implementation to minimise the number of fields and the grunt work needed to implement it?
Thanks in advance for any help!