"Ron Rosenfeld" wrote:

On Mon, 21 Nov 2005 12:59:06 -0800, "kp" wrote:

I have data from a CSV file that lists several thousand date and time values.
It extends over a 72 hour period. The values listed in the cells are the
standard date and time values (i.e., 11/15/05; and 00:00:0). The time values
are reported in 1 second increments. In a nearby column, I would like to
create a rolling sum, starting with time "zero", and ending with total time
reported in hours (approximately 72). I need it in this format so I can
graph it logarithmically.

Can't seem to get any calc to work.

kp

What formulas have you used?
What results are you seeing?

When you say you "need it in this format", what does "it" mean?

Decimal hours?

Excel stored time displayed as hours? (e.g. 72 hours would be 72:00:00)

Or something else?


--ron

Ron:

The data looks like this:

11/15/2005 00:00.0
11/15/2005 00:01.0
11/15/2005 00:02.0
11/15/2005 00:03.0

When you click on the cell, the 00:00.0 shows 9:00 AM.

I created a column and added the date to time value =b1+c1 to come up with
one cell of combined time/data (d1). I block copied that down for the entire
data set. I added another column (e) and inserted a formula (=d1-d1) into e1
to tally my running total. My intention was to block copy this down to the
entire dataset but it is not working.

I actually need my data in decimal minutes, not hours.

Thanks,

KP