LinkBack URL
About LinkBacks
Hi guys,
How do you convert 10.50 to 10m30sec(for example)? What is the simplest way to do that.
I've been searching for a solution but they all are too complicated.
Time Conversion/Decimal to Seconds
Hi guys,
How do you convert 10.50 to 10m30sec(for example)? What is the simplest way to do that.
I've been searching for a solution but they all are too complicated.
Last edited by geshwinn; 06-17-2010 at 03:54 AM.
divide 10.5 by 1440 format cell as mm:ss eg = a1/1440
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
In terms of the format you might want/need to use a format of: [m]"m"s"sec"
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks guys! It worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks