+ Reply to Thread
Results 1 to 1 of 1

How to sort data with date input

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    London
    MS-Off Ver
    Office 2010
    Posts
    5

    How to sort data with date input

    I have a huge CSV with dates and other data which is automatically refreshed on sheet 2 named "data".

    Heres a section of it:
    Date and time Screen Seconds Transaction number
    2012-09-04 23:38:42.440 Main Bar 1286 36659
    2012-09-04 23:01:25.330 Cutlery 3745 36659
    2012-09-04 23:01:25.330 Desserts 271 36659
    2012-09-04 23:01:25.330 Desserts 365 36659
    2012-09-04 23:01:25.330 Expo 513 36659
    2012-09-04 23:01:25.330 Expo 513 36659
    2012-09-04 22:25:20.447 Main Bar 3433 36707
    2012-09-04 21:54:07.680 Cutlery 218 36726
    2012-09-04 21:54:07.680 Pizza Collect 654 36726
    2012-09-04 21:54:07.680 Pizza Order 653 36726
    2012-09-04 21:52:25.450 Cutlery 320 36722
    2012-09-04 21:52:25.450 Pizza Collect 515 36722
    2012-09-04 21:52:25.450 Pizza Order 591 36722
    2012-09-04 21:50:34.743 Assembler 1532 36659
    2012-09-04 21:50:34.743 Assembler 1533 36659
    2012-09-04 21:50:34.743 Cutlery 10 36659
    2012-09-04 21:50:34.743 Expo 1608 36659
    2012-09-04 21:50:34.743 Expo 1608 36659
    2012-09-04 21:50:34.743 Pans 268 36659
    2012-09-04 21:50:34.743 Pans 292 36659
    2012-09-04 21:50:34.743 Pans 419 36659
    2012-09-04 21:50:34.743 Pans 420 36659
    2012-09-04 21:50:34.483 Cutlery 33 36719
    2012-09-04 21:50:34.483 Pizza Collect 428 36719
    On sheet 2, the time & date is displayed on column #1 is displayed as: 2012-09-04 23:38:42.440
    On sheet 1, there is a large table starting with predefined data as shown below.

    sheet.PNG

    What I need on sheet 1 is so that a user can input the date in cell A3 and the date will then automatically input into rows A5 to A36 as 'date' or 'number'.
    Then, column D would read that date in column A & the time period in column C and then pull the avarage time for that screen and convert from seconds to minutes from the sheet 2 "data" and fill it in as 'time' or 'numbers'.

    I've made it sound a lot more complicated than it already is, but I have no experience with excel so the terminology isn't all there!

    Attached is the actual document QSR Report Requests.xlsm
    Last edited by jmorton; 09-06-2012 at 09:30 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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