Time arrrggghhh

E

EARTHWALKER

This is doing my head in...as usual :D

Right... basically I have a spreadsheet with two 'time' columns, one i
just a time, the other is the time (in h/m/s) that elapsed between th
first entry and this one - e.g.

Time----------Duration
12:00:00-----00:00:00
12:00:05-----00:00:05
12:00:07-----00:00:07 ...etc

What I want to do is somehow get a series that tells me how many entry
appear in each block of five seconds, so I can graph it (these ar
logins to a website, in case anyone was curious) - so for the above, i
would be:

Start--------Hits
12:00:00----1
12:00:00----2

I've got almost everything done apart from the colums that calculate
the duration in seconds.

I used =(end-start)*24 and for duratons of just seconds; no miuntes o
more it was fine. If someone was logged onto the site for exactly
minute. That claculation returned 0. I tried the second function to
and got the same thing.
What's the function for calculating everthing in seconds, so if you ha
1:20:00 it would return the value of 3620

/me waits for Frank and his massive brain to come to EARTHY'
rescue...once again :cool
 
D

David Benson

Earthwalker,

You can multiply the Duration by 24*60*60 to convert it to seconds. Excel
will probably try to format this cell in time format for you -- you'll have
to manually set it to General. You might also have to use the ROUND
function to round the result off to an integer number of seconds -- when you
convert from fractions of a day to seconds, it's not likely to come out even
all the time.

By the way, 1:20:00 converts to 4800 seconds, not 3620.


-- David
 
E

EARTHWALKER

Thank you for that Dave. Much appreciated. Now fully working like i
should do :
 
Top