I have a data logger that creates a spreadsheet. In one of the fields is the
date and time in 10 min increments, the other field is the pump output. I
want to be able to do two things.

First is add all of the pump output from say 9am to 9pm on a given day
Second, I want to be able to add all of the pump output for a given day.

I need to do this calcuation hundreds of time, so I am hoping there is a
sumif that will work, I just cannot seem to make it work.

thanks

You will most likely be using a SUMPRODUCT() formula for these tasks. Read
through the complete primer found he

http://www.xldynamic.com/source/xld....T.html#classic

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Paul" wrote:

I have a data logger that creates a spreadsheet. In one of the fields is the
date and time in 10 min increments, the other field is the pump output. I
want to be able to do two things.

First is add all of the pump output from say 9am to 9pm on a given day
Second, I want to be able to add all of the pump output for a given day.

I need to do this calcuation hundreds of time, so I am hoping there is a
sumif that will work, I just cannot seem to make it work.

thanks

I think this might be helpful, and I am pretty well versed at figuring these
things out, but I cannot for the life of me figure out how to 'pull' the time
our of field that had both time and date information.

"JBeaucaire" wrote:

You will most likely be using a SUMPRODUCT() formula for these tasks. Read
through the complete primer found he

http://www.xldynamic.com/source/xld....T.html#classic

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Paul" wrote:

I have a data logger that creates a spreadsheet. In one of the fields is the
date and time in 10 min increments, the other field is the pump output. I
want to be able to do two things.

First is add all of the pump output from say 9am to 9pm on a given day
Second, I want to be able to add all of the pump output for a given day.

I need to do this calcuation hundreds of time, so I am hoping there is a
sumif that will work, I just cannot seem to make it work.

thanks

To separate the time from a date/time:

A1 = 1/1/2009 12:00 PM (as a true Excel date/time)

=MOD(A1,1)

Formatted as General or Number the result is 0.05.

Formatted as Time the result is 12:00 PM.

To separate the date from a date/time:

=INT(A1)

Formatted as General or Number the result is 39814.

Formatted as Date the result is 1/1/2009.

--
Biff
Microsoft Excel MVP


"Paul" wrote in message
...
I think this might be helpful, and I am pretty well versed at figuring
these
things out, but I cannot for the life of me figure out how to 'pull' the
time
our of field that had both time and date information.

"JBeaucaire" wrote:

You will most likely be using a SUMPRODUCT() formula for these tasks.
Read
through the complete primer found he

http://www.xldynamic.com/source/xld....T.html#classic

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Paul" wrote:

I have a data logger that creates a spreadsheet. In one of the fields
is the
date and time in 10 min increments, the other field is the pump output.
I
want to be able to do two things.

First is add all of the pump output from say 9am to 9pm on a given day
Second, I want to be able to add all of the pump output for a given
day.

I need to do this calcuation hundreds of time, so I am hoping there is
a
sumif that will work, I just cannot seem to make it work.

thanks

0.5 rather than 0.05, but otherwise correct, of course.
--
David Biddulph

"T. Valko" wrote in message
...
To separate the time from a date/time:

A1 = 1/1/2009 12:00 PM (as a true Excel date/time)

=MOD(A1,1)

Formatted as General or Number the result is 0.05.

Formatted as Time the result is 12:00 PM.

To separate the date from a date/time:

=INT(A1)

Formatted as General or Number the result is 39814.

Formatted as Date the result is 1/1/2009.

--
Biff
Microsoft Excel MVP


"Paul" wrote in message
...
I think this might be helpful, and I am pretty well versed at figuring
these
things out, but I cannot for the life of me figure out how to 'pull' the
time
our of field that had both time and date information.

"JBeaucaire" wrote:

You will most likely be using a SUMPRODUCT() formula for these tasks.
Read
through the complete primer found he

http://www.xldynamic.com/source/xld....T.html#classic

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Paul" wrote:

I have a data logger that creates a spreadsheet. In one of the fields
is the
date and time in 10 min increments, the other field is the pump
output. I
want to be able to do two things.

First is add all of the pump output from say 9am to 9pm on a given day
Second, I want to be able to add all of the pump output for a given
day.

I need to do this calcuation hundreds of time, so I am hoping there is
a
sumif that will work, I just cannot seem to make it work.

thanks

0.5 rather than 0.05

It was late and my vision was blurred. The 22 beers I drank didn't have
anything to do with it! <g

--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
0.5 rather than 0.05, but otherwise correct, of course.
--
David Biddulph

"T. Valko" wrote in message
...
To separate the time from a date/time:

A1 = 1/1/2009 12:00 PM (as a true Excel date/time)

=MOD(A1,1)

Formatted as General or Number the result is 0.05.

Formatted as Time the result is 12:00 PM.

To separate the date from a date/time:

=INT(A1)

Formatted as General or Number the result is 39814.

Formatted as Date the result is 1/1/2009.

--
Biff
Microsoft Excel MVP


"Paul" wrote in message
...
I think this might be helpful, and I am pretty well versed at figuring
these
things out, but I cannot for the life of me figure out how to 'pull' the
time
our of field that had both time and date information.

"JBeaucaire" wrote:

You will most likely be using a SUMPRODUCT() formula for these tasks.
Read
through the complete primer found he

http://www.xldynamic.com/source/xld....T.html#classic

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Paul" wrote:

I have a data logger that creates a spreadsheet. In one of the
fields is the
date and time in 10 min increments, the other field is the pump
output. I
want to be able to do two things.

First is add all of the pump output from say 9am to 9pm on a given
day
Second, I want to be able to add all of the pump output for a given
day.

I need to do this calcuation hundreds of time, so I am hoping there
is a
sumif that will work, I just cannot seem to make it work.

thanks