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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I convert 00:03:54 to get 234 seconds? (https://www.excelbanter.com/excel-worksheet-functions/19363-how-do-i-convert-00-03-54-get-234-seconds.html)

SteverinoNeedsHelp

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

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?

Bob Phillips

=A1*24*60*60

--

HTH

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

"SteverinoNeedsHelp" wrote in
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?

RagDyeR

Custom format:

[ss]
--

HTH,

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

"SteverinoNeedsHelp" wrote in
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?

All times are GMT +1. The time now is 05:50 AM.