LinkBack URL
About LinkBacks
I have two variables (mm and ss) (singles) that i want to place into a single Range on a sheet. They are minutes and seconds and I would like the results to be mm:ss. Any help would be appreciated.
Put into a single Range two variables mm and ss
I have two variables (mm and ss) (singles) that i want to place into a single Range on a sheet. They are minutes and seconds and I would like the results to be mm:ss. Any help would be appreciated.
Here's one way:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
This works fine except when the seconds are less than 10 the number. For example, given mm = 1 and ss = 9 it shows up as 1:9. Is there a way for it to be 1:09??
Maybe:
And thanks for the rep!Please Login or Register to view this content.
Last edited by xladept; 03-07-2018 at 06:22 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks