Time calculations

  • Thread starter Thread starter Rick Ratzlaff
  • Start date Start date
R

Rick Ratzlaff

I have a colume, say "F" with some time stamps in it. The
rows are sequential times as it is derived from a
imported .csv file from a nother device. Therefore in
column "G" I have a calculation that subtracts R2 from R1
to give me a cylce or laps time. So now in colume "H" I
want to put in a formula that multiplies 3600 (which is
the number of seconds in a hour) times the cycle time to
tell me how many cycles there should be in 1 hour. When I
do that I get huge numbers. I've tried all format types to
no avail? Stumped Thanks in advance!
 
Rick,

Doesn't

=1/(G2*24)

give the cycles per hour

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Yeh - thanks - What in the world is the "1" doing?
-----Original Message-----
Rick,

Doesn't

=1/(G2*24)

give the cycles per hour

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Back
Top