+ Reply to Thread
Results 1 to 2 of 2

Counting times and interpreting data

  1. #1
    Registered User
    Join Date
    01-05-2015
    Location
    London
    MS-Off Ver
    2011
    Posts
    1

    Question Counting times and interpreting data

    Hi!

    I'm supposed to make a spreadsheet where one selects an item from a drop-down menu and then clicks on a button to 'start' when they start handling that item and 'finish' when they're done with it. These items are dealt with at various moments during the day. At the end of the day the average, maximum and minimum times have to be calculated. How can this be done, as easily as possible?

    Thanks in advance,
    Edson

  2. #2
    Registered User
    Join Date
    09-01-2011
    Location
    georgia
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Counting times and interpreting data

    There is very little information that you have given to go on. With that said, it sounds like you're looking to log check-in/out times for unique items so that you can sort how long each items was used.

    I recommend checking researching data entry through a custom user form. Without any more to go on, I'm afraid we can't be of much help. If you have an idea of how you want to handle it but aren't sure how to get there, please put together a sample spreadsheet with the data and how you want it to look and some of us may be able to point you down the right path.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Counting the number of times the same data appears in a table
    By dispro14 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2014, 07:04 AM
  2. [SOLVED] Counting the number of times a time appears in a range of data
    By alexw1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-04-2013, 12:23 PM
  3. Excel Logic Question - Interpreting data
    By nobodyukno in forum Excel General
    Replies: 3
    Last Post: 07-23-2013, 06:14 PM
  4. Counting Data Between Two Set TImes
    By panicwithpandah in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-28-2013, 01:49 AM
  5. Counting Times?
    By aidan80 in forum Excel General
    Replies: 4
    Last Post: 06-05-2009, 06:26 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1