Share via

Restaurant Ticket Time Calculation

Anonymous
2014-10-01T19:29:55+00:00

In need of a little bit of help. I am trying to create a tracking sheet for my restaurant that allows me to keep track of ticket times and average them out. I am a new excel user so this may be rather simple but i am having difficulties. I have to this point been inputting the data with Columns titled DATE, LUNCH IN, LUNCH OUT, DINNER IN, DINNER OUT, and TIME(MIN) for both lunch and dinner

I have figured out calculation of ticket times even though it looks a little sloppy lol. I am wondering if there is a cleaner way to do this so that i can present it and how i can keep a running average to ensure ticket times are coming out at required intervals. When i try and average i feel like its dividing by the total number of columns rather than just the ones that have actual amounts of times. Any suggestions in this matter would be greatly appreciated. I apologies for the length but did not know how to explain what i was trying to do as i could not find a template that would work for what i wanted so had to create my own and am still new to excel.

DATE Lunch In Lunch Out Time (Min) Dinner In Dinner Out Time(Min)
9/19/2014 0:00 6:52 PM 7:07 PM 0:15
9/19/2014 0:00 6:49 PM 7:01 PM 0:12
9/19/2014 0:00 6:42 PM 6:58 PM 0:16
9/19/2014 0:00 6:37 PM 6:50 PM 0:13
9/19/2014 0:00 6:36 PM 6:48 PM 0:12
9/19/2014 0:00 6:07 PM 6:17 PM 0:10
9/19/2014 0:00 5:52 PM 6:02 PM 0:10
9/19/2014 0:00 5:37 PM 5:53 PM 0:16
9/19/2014 0:00 5:29 PM 5:44 PM 0:15
9/19/2014 1:19 PM 1:27 PM 0:08 0:00
9/19/2014 1:16 PM 1:25 PM 0:09 0:00
9/19/2014 1:00 PM 1:12 PM 0:12 0:00
9/19/2014 1:00 PM 1:10 PM 0:10 0:00
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Ashish Mathur 101.8K Reputation points Volunteer Moderator
2014-10-01T22:50:00+00:00

Hi,

Try this

=AVERAGEIF($D$2:$D$20,">0",$D$2:$D$20)

Hope this helps.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-10-01T19:52:30+00:00

    Re:  calculating average

    The Average function ignores blank cells and cells with text.

    It includes cells containing a zero.

    The quick answer to your issue is to remove the zero's or have your ticket time formulas return an empty string "" instead of a zero.

    '---

    Jim Cone

    Portland, Oregon USA

    https://goo.gl/IUQUN2 (Dropbox)

    (free & commercial excel add-ins & workbooks)

    Was this answer helpful?

    0 comments