Calculations from date and time values
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
|