[ibm37]

I have a spreadsheet with 'Times' displayed in a column i.e 00:04:15
and what i would like is a column next to this to automatically display
the number of seconds in total? and I assume their is some automatic
process/formula for this??

Thanks

 

[etaf]

there may be a better way
but this will convert to secinds
=(HOUR(E6)*60*60)+((MINUTE(E6))*60)+SECOND(E6)

make sure you format the cell this formula is in general /number - NOT date

 

[bomb #21]

Or:
=range*86400

(60*60*24)

 

[ibm37]

excellent.. so how do i implement this on a given column? i.e column A has all the times, and when these are entered the seconds are entered in column B? Or atleast how
do i go about doing the selected Column A now that has the Times? (other than pasting formula's in each cell and changing the cell ref.)

 

[Zack Barresse]

Enter the formula and copy it down (hover your pointer over the bottom right corner of the formula cell until the cursor becomes a bold + sign, then double click). There isn't anything automatic about it. If you wanted to do so, you would either need to go into Tools | Options | Calculation (tab, I think..), Extend data formats and formulas. If you do so, read the help files on how it works exactly.

HTH

 

[ibm37]

Thanking you all