How do I convert 00:03:54 to get 234 seconds?

G

Guest

how do I convert 3 minutes and 54 seconds (00:03:54) to get the answer 234
seconds? I have tried all the formulas for time conversions, but none will
let me take the full minutes and seconds and convert it to all seconds. Any
ideas?
 
B

Bob Phillips

=A1*24*60*60

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

RagDyeR

Custom format:

[ss]
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

message how do I convert 3 minutes and 54 seconds (00:03:54) to get the answer 234
seconds? I have tried all the formulas for time conversions, but none will
let me take the full minutes and seconds and convert it to all seconds. Any
ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change a minutes and seconds as a 2400 time to seconds? 1
how to convert whole numbers representing seconds to mm:ss 2
Convert Seconds to Minutes 11
Converting time :: Excell 2007 5
How do I sum increments of minutes and seconds 5
Add Seconds to Date - Time Field 2
Conditional Time Calculation 10
Convert seconds into hours:minutes:seconds 2

Top