Time calculations

[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!

 

[Bob Phillips]

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)

 

[Rick]

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)




.

 

[Peo Sjoblom]

1 is one day in excel, thus 1/24 is one hour