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]
[/pre]
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