• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum if for a specific time limit

tinumathews

New Member
Hi,

The data is as shown below Date in column A, Time in B and values in C. I need to sum the values in coulmn C for the times starting from 7:00 PM a day and ending 6:00 AM the next day. The sum is done for 24 hrs. which would run into the next day. Any help in this area would be helpful.

[pre]
Code:
A              B           C
Date            Time       Values
1-Jan-13	7:00 AM      10
1-Jan-13	8:00 AM      10
1-Jan-13	9:00 AM      10
1-Jan-13	10:00 AM     5
1-Jan-13	11:00 AM     6
1-Jan-13	12:00 PM     7
1-Jan-13	1:00 PM      10
1-Jan-13	2:00 PM
1-Jan-13	3:00 PM
1-Jan-13	4:00 PM
1-Jan-13	5:00 PM
1-Jan-13	6:00 PM
1-Jan-13	7:00 PM
1-Jan-13	8:00 PM
1-Jan-13	9:00 PM
1-Jan-13	10:00 PM
1-Jan-13	11:00 PM
2-Jan-13	12:00 AM
2-Jan-13	1:00 AM
2-Jan-13	2:00 AM
2-Jan-13	3:00 AM
2-Jan-13	4:00 AM
2-Jan-13	5:00 AM
2-Jan-13	6:00 AM
[/pre]
 
Hi tinumathews,


See whether this give result or not:


http://dl.dropbox.com/u/60644346/SumByTime.xlsx


Regards,

Faseeh
 
Hi Tinu ,


I have used Faseeh's file , added some more data , and changed the formulae , using two helper columns.


http://speedy.sh/UWhZd/SumByTime-1.xlsx


Narayan
 
Back
Top