Summing a Value within a Specific Time Frame

cgolds

New Member
Joined
Feb 4, 2006
Messages
18
I have a file that contains values gathered at 15-minute intervals for an entire day for hundreds of meters. I need to sum these values by each hour for each meter. Most of the entries contain values for each 15-minute period in the each hour (0:15, 0:30, 0:45, 1:00), but not all show all four intervals. Any suggestions?


Meter Number Interval Start Interval End End Hour Interval Value
128026480 7/12/2018 0:00 7/12/2018 0:15 12:15 AM 0.16
128026480 7/12/2018 0:15 7/12/2018 0:30 12:30 AM 0.19
128026480 7/12/2018 0:30 7/12/2018 0:45 12:45 AM 0.20
128026480 7/12/2018 0:45 7/12/2018 1:00 1:00 AM 0.21
128026480 7/12/2018 1:00 7/12/2018 1:15 1:15 AM 0.21
128026480 7/12/2018 1:30 7/12/2018 1:45 1:45 AM 0.22
128026480 7/12/2018 1:45 7/12/2018 2:00 2:00 AM 0.20
128026480 7/12/2018 2:00 7/12/2018 2:15 2:15 AM 0.20
128026480 7/12/2018 2:45 7/12/2018 3:00 3:00 AM 0.18
128026480 7/12/2018 3:30 7/12/2018 3:45 3:45 AM 0.14
128026480 7/12/2018 3:45 7/12/2018 4:00 4:00 AM 0.15
128026480 7/12/2018 4:00 7/12/2018 4:15 4:15 AM 0.14
128026480 7/12/2018 4:15 7/12/2018 4:30 4:30 AM 0.13
128026480 7/12/2018 4:30 7/12/2018 4:45 4:45 AM 0.13
128026480 7/12/2018 4:45 7/12/2018 5:00 5:00 AM 0.13
128026480 7/12/2018 5:00 7/12/2018 5:15 5:15 AM 0.13
128026480 7/12/2018 5:30 7/12/2018 5:45 5:45 AM 0.06
128026480 7/12/2018 5:45 7/12/2018 6:00 6:00 AM 0.04
128026480 7/12/2018 6:00 7/12/2018 6:15 6:15 AM 0.05
128026480 7/12/2018 6:15 7/12/2018 6:30 6:30 AM 0.06
128026480 7/12/2018 6:30 7/12/2018 6:45 6:45 AM 0.05
128026480 7/12/2018 6:45 7/12/2018 7:00 7:00 AM 0.04
128026480 7/12/2018 7:00 7/12/2018 7:15 7:15 AM 0.02
128026480 7/12/2018 7:15 7/12/2018 7:30 7:30 AM 0.06
128026480 7/12/2018 7:30 7/12/2018 7:45 7:45 AM 0.05
128026480 7/12/2018 7:45 7/12/2018 8:00 8:00 AM 0.04
128026480 7/12/2018 8:00 7/12/2018 8:15 8:15 AM 0.07
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,095,234
Messages
5,443,269
Members
405,222
Latest member
Summer01

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top