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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. uklaffin

    ROUNDUP Time?

    Thank you both for your time....It's sorted now.
  2. uklaffin

    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.
  3. uklaffin

    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?
  4. uklaffin

    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.

Part and Inventory Search

Back
Top