Converting mins/secs into secs

[Guest]

Hi,

I was wondering if there was an easy way to convert the following into just seconds

0:00:15 = 15 sec
0:00:20 = 20 sec
0:02:51 = 171 sec
0:01:21 = 81 sec
0:00:19 = 19 sec
0:01:28 = 68 sec
0:02:33 = 153 secs
etc et

I have about 5000 lines of these and doing this manually would just take too long.

The format being used is eg. 12:02:51 AM and is being displayed as "0:02:51" but I would just like "171" sec

Is there an easier way

Thanks for any help

Monik

 

[Steven]

column A is formated as time
A B
0:02 171
0:00:20 20
0:00:15 15


Enter this formula into B1 and copy down to b2 & b3
=A1*60*24*60

format column B as a general number

you can then copy column B & past special (values only) to get rid of the
formula

Hi,

I was wondering if there was an easy way to convert the following into just seconds:

0:00:15 = 15 secs
0:00:20 = 20 secs
0:02:51 = 171 secs
0:01:21 = 81 secs
0:00:19 = 19 secs
0:01:28 = 68 secs
0:02:33 = 153 secs
etc etc

I have about 5000 lines of these and doing this manually would just take too long.

The format being used is eg. 12:02:51 AM and is being displayed as

"0:02:51" but I would just like "171" secs

 

[JE McGimpsey]

If you just want to display seconds, choose Format/Cells/Number/Custom

[ss]

 

[Guest]

Hi Steven,

Your help has been really great as your formula worked perfectly.
Thanks very much for your help.

Regards
Monika