Results 1 to 3 of 3

Hourly data

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    11

    Hourly data

    Hi All

    Would appreciate if i could get help on this subject. In the file below i have data every 5 mins. However, I wish to separate the data such that i have hourly data, i.e. take out every row whose time ends with a 00, like 7:00 and 8:00 etc. As it is in the format of time, i can't retain just the last 2 digits and separate from there...could anyone help please?
    Attached Files Attached Files
    Last edited by liawsiqin@gmail; 12-22-2010 at 03:33 PM.

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