-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
invitation to become a member of DRAFT
- Thread starter erik.van.geit
- Start date
Excel Facts
Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,030
Don't want to side-track Erik's thread too much here; but just wanted to say "congratulations, Aaron!" Over the course of the last year and a half I have (a) lost 65 pounds then (b) gained back 20 and (c) lost 30, so I'm down a net 75 pounds. So I know how much hard work and determination goes into it. So, again, <font color=blue style="background: url(http://www.balloondoggies.com/vonpookie/misc/sparkle.gif)">congratulations!</font>
OK - back to discussing avatars...actually TrippyTom, I thought of yours when HalfAce made that comment...
Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,030
Paul,
Yes, much better. But like I said in the other thread, I'd need a draft horse to joust. In spite of dropping over five stone, I still weigh over 20 ½ stone. Which brings me to...
Aaron,
Did it all on my own through hundreds of hours of cardio and hundreds of hours of lifting weights and miles of swimming and cleaning up my diet. Nothing Draconian on the diet. No "program"; because sooner or later you have to "go back to normal" or the cravings will drive you to a gallon of ice cream at three o'clock in the morning. So no "limiting calories" per se. Just eating healthy food like fruits, nuts and salad instead of candy bars and avoiding sugar-laden beverages like pop or Kool-Aid.
OK - that's it for me for a while. I've spent half my morning fiddly-fartin' around in the MrExcel lounge today!
Yes, much better. But like I said in the other thread, I'd need a draft horse to joust. In spite of dropping over five stone, I still weigh over 20 ½ stone. Which brings me to...
Aaron,
Did it all on my own through hundreds of hours of cardio and hundreds of hours of lifting weights and miles of swimming and cleaning up my diet. Nothing Draconian on the diet. No "program"; because sooner or later you have to "go back to normal" or the cravings will drive you to a gallon of ice cream at three o'clock in the morning. So no "limiting calories" per se. Just eating healthy food like fruits, nuts and salad instead of candy bars and avoiding sugar-laden beverages like pop or Kool-Aid.
OK - that's it for me for a while. I've spent half my morning fiddly-fartin' around in the MrExcel lounge today!
Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
Only half? Amateur. 
