When you get older, like me, time appears to go faster... it **seemed** like
a year to me<g; but yes, you are right, there are 86400 seconds in a
**day**, not a year (of course, the formula still works correctly, in spite
of this misstatement in my attempt to explain why). Thanks for noting that.
Rick
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
In a day, rather than in a year, I hope, Rick?
--
David Biddulph
"Rick Rothstein (MVP - VB)" wrote in
message ...
Try this...
=86400*("00"&G2)
where 86400 is the number of seconds in a year and, when the
concatenation is multiplied by it, the concatenation is turned into an
actual time value (because your value has a time format except for the
missing hours part... which the concatenation puts in).
Rick
"Phredd" wrote in message
...
I have data that I export to Excel where the total time comes in as
:mm:ss.
I need to convert that format into seconds. For example, my report
shows me
:01:25, I need to be able to show that at 85 seconds. I have a formula
that
will convert mm:ss to seconds which is =INT(G2)*60+((G2-INT(G2))*100)
where
G2 is 01:25 the result will be 85. but the report i have now comes with
an
extra :. I cannot seem to be able to automatically remove the : at the
begining of the expression or modify my formula above to account for the
extra :. I am sure this is pretty simple it is just beyone me though.
Any
help will be much appreciated!
Phredd