Changing Work column decimal format?

G

G Lykos

Greetings! Am looking for a way to change the Work column fixed (?) decimal
format from two to none in the interest of gaining more table real estate
while avoiding ###'s.

Thanks,
George
 
B

Brent

You need to modify one of your customizeable task fields of type
Number. First you have to get rid of the units and also get rid of the
numbers after the decimal. If you use hours as your default units,
then in your field that you are customizing create the following
formula:
Int(([Work]/60))

The [Work]/60 gets rid of the displayed units.
The function Int gives your the integer only.
Hope it works. If not get back to me.

Take care,
Brent
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top