Hi All
Got a formula problem I cant seem to solve, no matter how much I rack my brain (attached an example workbook)
Scenario
I've got an outdoor food market open 24 hours, 3 days a week. Majority of visitors arrive at night time around 6pm onwards. Column G shows % of arrivals by time of entry.
On average they stay about 2 - 3 hours and spend $50-60, I've estimated their spend over time in Column J.
Problem
Now lets say I only had 10 visitors, I want to plot the time they arrive onto Column M. BUT obviously you cant have a fraction of a person. How can I accurately plot 10 people as per example on this??
Bookmarks