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

S

SteverinoNeedsHelp

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

Conditional Time Calculation 10
Outlook crashes to an extremely slow pace, approx 3 seconds after starting, and affects other applications the same way. I have tried all the fixes 0
Time Zone Conversion Table 1
Converting Seconds to Hours, Minutes, Seconds 3
Converting time :: Excell 2007 6
How do I change a minutes and seconds as a 2400 time to seconds? 1
Formatting time in Excel 2007 3
converting a decimal to time 3

Top