Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by uklaffin
-
ROUNDUP Time?
Thank you both for your time....It's sorted now.- uklaffin
- Post #7
- Forum: Microsoft: Office
-
ROUNDUP Time?
Excellent! =ROUNDUP(A1*1440,0)/1440 works, don't suppose you know how to convert it to a number eg: Change 01:01:32 (hh:mm:ss) to 63 (with the roundup included) Thanks for your time.- uklaffin
- Post #5
- Forum: Microsoft: Office
-
ROUNDUP Time?
Thanks euskadi. I still can't get the formula to work if I use =roundup(A1*24,0) all it returns is 1 I've tried it on the following (hh:mm:ss) examples: 00:02:22 00:03:07 00:25:29 00:01:29 Any other ideas?- uklaffin
- Post #3
- Forum: Microsoft: Office
-
ROUNDUP Time?
Hi, Does anybody know how to 'roundup' time and convert it to a number? eg. I need 00:01:26 (hh:mm:ss)to be rounded up to 2 I haven't used Excel for years! Thanks.- uklaffin
- Thread
- Replies: 6
- Forum: Microsoft: Office
