AnsweredAssumed Answered

Visual Timeline for Shop Opening Hours

Question asked by keefbc on May 20, 2014
Latest reply on May 21, 2014 by CarlSchwarz

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!

Attachments

Outcomes