+ Reply to Thread
Results 1 to 8 of 8

Convert rainfall data from 10 minutes to 20 min,30 min,1 hr ..

  1. #1
    Registered User
    Join Date
    03-17-2015
    Location
    ppp
    MS-Off Ver
    2013
    Posts
    10

    Convert rainfall data from 10 minutes to 20 min,30 min,1 hr ..

    i have rainfall data every 10 min and i need to find from this data the rainfall every 20 min , 30 min ,1 hr ets
    my data here

    data.xlsx
    10
    DT RD
    10/29/2004 0:00 0
    10/29/2004 0:10 0
    10/29/2004 0:20 0
    10/29/2004 0:30 0
    10/29/2004 0:40 0
    10/29/2004 0:50 0
    10/29/2004 1:00 0
    10/29/2004 1:10 0
    10/29/2004 1:20 0
    10/29/2004 1:30 0
    10/29/2004 1:40 0
    10/29/2004 1:50 0
    10/29/2004 2:00 0
    10/29/2004 2:10 0
    10/29/2004 2:20 0
    10/29/2004 2:30 0

    please help me

  2. #2
    Registered User
    Join Date
    03-17-2015
    Location
    ppp
    MS-Off Ver
    2013
    Posts
    10

    Re: Convert rainfall data from 10 minutes to 20 min,30 min,1 hr ..

    the data herrrrrre
    Attached Files Attached Files

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Convert rainfall data from 10 minutes to 20 min,30 min,1 hr ..

    Do you want this cumulative?
    =SUM($E$3:E3)

    If that is not what you wanted, please show some sample answers?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    03-17-2015
    Location
    ppp
    MS-Off Ver
    2013
    Posts
    10

    Re: Convert rainfall data from 10 minutes to 20 min,30 min,1 hr ..

    yes i need cumulative but the data is large so i **** do the sum
    sample
    Attached Files Attached Files

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Convert rainfall data from 10 minutes to 20 min,30 min,1 hr ..

    So if that did not work for you, where is the sample answers of what you want?

  6. #6
    Registered User
    Join Date
    03-17-2015
    Location
    ppp
    MS-Off Ver
    2013
    Posts
    10

    Re: Convert rainfall data from 10 minutes to 20 min,30 min,1 hr ..

    i attached the sample with name book2
    the data is in 10 min converted to data in 20min and 30min

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Convert rainfall data from 10 minutes to 20 min,30 min,1 hr ..

    If your times are already there...
    E3=SUMIF($B:$B,"<="&D3,$C:$C)
    G3=SUMIF($B:$B,"<="&F3,$C:$C)

  8. #8
    Registered User
    Join Date
    03-17-2015
    Location
    ppp
    MS-Off Ver
    2013
    Posts
    10

    Re: Convert rainfall data from 10 minutes to 20 min,30 min,1 hr ..

    i dont need the sum example
    time R time R time R
    10 1 20 6 30 9
    20 5 40 5 60 14
    30 3 60 12
    40 2
    50 4
    60 8

+ 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. Replies: 1
    Last Post: 10-23-2015, 07:20 PM
  2. convert days hours minutes seconds to just minutes
    By hollylynn in forum Excel General
    Replies: 4
    Last Post: 08-28-2015, 08:53 AM
  3. Excel 2007 : Convert number of minutes to hours and minutes
    By MikeFromIndy in forum Excel General
    Replies: 30
    Last Post: 06-05-2015, 08:10 AM
  4. Convert Days:Hours:Minutes:seconds to minutes.
    By Kevingardner1 in forum Excel General
    Replies: 4
    Last Post: 06-03-2014, 06:44 PM
  5. Replies: 1
    Last Post: 08-08-2013, 09:21 AM
  6. trying to convert a number into minutes and add minutes to a starting time
    By crbazzer in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-28-2013, 09:26 AM
  7. Counting Rainfall Data
    By TightIsobars in forum Excel General
    Replies: 2
    Last Post: 01-17-2005, 08:06 PM

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