How do I convert (hh/?mm/ss) or ( hh:mm:ss) to seconds
R RedChequer Oct 1, 2004 #3 Thanks Bob Keith Bob Phillips said: =J1*24*60*60 or =CONVERT(J1,"day","sec") -- HTH RP Click to expand...
Thanks Bob Keith Bob Phillips said: =J1*24*60*60 or =CONVERT(J1,"day","sec") -- HTH RP Click to expand...
R RedChequer Oct 2, 2004 #4 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
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
