Easy Excel question

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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

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.
 
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Members online

Top