convert to seconds

Guest · Sep 30, 2004

How do I convert (hh/?mm/ss) or ( hh:mm:ss) to seconds

Bob Phillips · Sep 30, 2004

=J1*24*60*60

or

=CONVERT(J1,"day","sec")

Guest · Oct 1, 2004

Thanks Bob
Keith

Bob Phillips said:
=J1*24*60*60

or

=CONVERT(J1,"day","sec")

--

HTH

RP

Guest · Oct 2, 2004

Bob,
I discovered that if I format column A to hh/mm/ss format then enter
08:14:52
in A1 and in B1 the formula =A1*86400 it will do the job.
Keith

MROUND time	2	Oct 12, 2009
Issue with a macro	18	Sep 9, 2009
time questions (roundup & convert hh to mm	1	May 18, 2006
How to convert MM/DD/YYYY to Month	2	Feb 21, 2010
convert dd:hh:mm:ss to seconds	5	Jul 17, 2009
Displaying Degrees Minutes Seconds	1	Jul 11, 2003
Averaging Time	4	Jan 29, 2007
display no seconds in time format [h]	1	Oct 3, 2005

Ask a Question