Hi Guys,
i want to use VBA to round up minutes in time string:
1. TimeToChange = "00:10:39" (hh:mm:ss) should be rounded to "0:11" (h:mm)
1. TimeToChange = "00:00:30" (hh:mm:ss) should be rounded to "0:01" (h:mm)
What formula i can use?
Jacek
Hi Guys,
i want to use VBA to round up minutes in time string:
1. TimeToChange = "00:10:39" (hh:mm:ss) should be rounded to "0:11" (h:mm)
1. TimeToChange = "00:00:30" (hh:mm:ss) should be rounded to "0:01" (h:mm)
What formula i can use?
Jacek
Play around with this...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Please Login or Register to view this content.
Or...
Please Login or Register to view this content.
Another alternative is (close to sintek's #2 ):
Please Login or Register to view this content.
Last edited by Haluk; 08-02-2020 at 09:12 AM.
And one more...
Please Login or Register to view this content.
Thank you Guys very much!!
Jacek
Jacek, you're welcome and thx for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks