1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Easy Excel question

Discussion in 'Business Applications' started by Dean5, Jan 16, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. Dean5

    Dean5 Thread Starter

    Joined:
    Feb 23, 2002
    Messages:
    17
    I will have cells g18:J32 that will have hours entered in them. Sometimes they might enter a number like 1.5 or 2.5 in those cells. I'd like for those cells to round down.
     
  2. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
    Ta ke a look at http://www.cpearson.com/excel/overtime.htm for an idea on how to organise a Timesheet record.


    The only way I know how to do a rounddown function is through a function, which means it would call the information from a specific cell.

    =ROUNDDOWN(A1,0) would look to cell a1 and round the number down to the nearest whole number, so 1.5 becomes 1, and 2.5 becomes 2, etc.


    You can do these calculations elsewhere on the sheet, and then display the totals nearby, but you would need to have someone who was better in vb to be able to write you a code that would automatically change the values in the cells, after you input them.


    hang around till someone more knowledgeable in VB comes around.
     
  3. Dean5

    Dean5 Thread Starter

    Joined:
    Feb 23, 2002
    Messages:
    17
    Tried the Valadation box route. With a prompt of Whooops! "Whole numbers please."
    Now if my boss will just approve this.
    Thanks so much for your help and advice.
     
  4. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
    and I was just thinking about this thread this afternoon!!!


    Anyway, I would suggest you go to Office Experts Forums cause they ROCK in all things Office.

    Another, VERY good, Excel resource would be Mr.Excel


    I'm sorry I did not suggest them before, but I had my head up my arse!!:D;)

    Good luck.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/113662

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice