Convert time to Seconds

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi Folks,
How do I convert a time in cell A1 in the format of eg
01:06:19 to seconds in cell B1 so that I see 3625. tia John
 
Hi John

multiply the cell with 1440 (24*60) and format the target cell as
number/general

HTH
Frank
 
3625? Why? Must 01:06:19 be 3979?

B1: Formula =A1/"0:0:1"
B1: Format General

--
Mike

Hi Folks,
How do I convert a time in cell A1 in the format of eg
01:06:19 to seconds in cell B1 so that I see 3625. tia John
 
Hi John!

Since time is expressed as a decimal of one day:

Use a helper column to convert using:

=A1*(24*60*60)

Having converted you can:

Copy the cells and then use Paste Special > Values >OK

Or do it direct:

Put 86400 in a cell
Copy that cell
Select the times to be converted
Edit > Paste SpeciaL > Multiply > OK

BTW 1:06:19 should be 3979
=(66*60)+19

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
John

With great difficulty......<g>

1 hour, six minutes, 19 seconds is 3979 seconds total.

in B1 enter =A1*86400 Format as number or general.

Gord Dibben Excel MVP
 
Sorry about the 3625 problem...............its late on a Sunday night and
I`v been
sweating over a hot workbook all weekend. Thanks all for the help. John
 
Back
Top