Hi
I am importing data that is taken hourly for and uncertain amount of
time. I need to take a total of flow rate daily and I wrote this:

x = 2
Do While Cells(x, 1).Value = Cells(x + 1, 1).Value
Cells(x + 1, 10).Value = Cells(x + 1, 9).Value + Cells(x,
10).Value
x = x + 1

Loop

So I'm comparing each entry's date to each other. But it only works
for the first 24 hours. I know its because it gets to the point where
the day does not equal each other but I cannot figure out a way to
over come it. Can anyone help me?