Actual Work

[txtoto]

How can I create a formula within Project that will round actual hours to .25
ranges. For example:

if actual work < .13, .25 (.13 will become .25)
if actual work > .12, 0 (.12 will become 0)

In this way, actual hours would always round to the nearest 1/4.

Thanks!

 

[davegb]

How can I create a formula within Project that will round actual hours to .25
ranges. For example:

if actual work < .13, .25 (.13 will become .25)
if actual work > .12, 0 (.12 will become 0)

In this way, actual hours would always round to the nearest 1/4.

Thanks!

A macro could do this. But why? My experience is that, unlrss you're
doing plant turnarounds, or something similar, and you're tracking to
..25 hrs, you're probably so lost in details that you've forgotten the
main purpose of tracking. Or even the main purpose of Project
Management.

Hope this helps in your world.

 

[txtoto]

Thanks for your help! Our projects are relatively small and we bill to the
1/4 hour; therefore we need actual hours to round up/down to the 1/4 hour.
Where can I go to learn how to create a macro? Project help really isn't
much help.

 

[davegb]

Thanks for your help! Our projects are relatively small and we bill to the
1/4 hour; therefore we need actual hours to round up/down to the 1/4 hour.
Where can I go to learn how to create a macro? Project help really isn't
much help.

I should warn you that Project is not timekeeping software. There are
software programs designed to do that and to integrate with Project. I
imagine if you Google for them, you'll find a few.

As for learning VBA. It's not really like a macro language, more like a
programming language (like Visual Basic! How strange.) It's not
something you learn in a day or two. If you google in this NG for it,
you'll find some resources to get you started.

I think that by the time you learn VBA enough to do what you want,
you'll have spend a lot more than the add-on software would cost.

Hope this helps.

 

[DavidC]

Hi,

Try playing with the custom fields. Add a custom text field (say text1) and
click on the formula option. This will allow you to create a formula looking
like IIF([Actual Duration]>.13,.25,0). This will assume a couple of settings.

First that you have the default work set in hours.
Second that all durations are in parts of hours. If not then you will need
to split the actual hours into whole hours and part hours, then run the IIF
formula above to change the part hours into the .25hr segements, then add the
whole hours back to the new part hours. This will require three custom
fields.

1 to hold the whole hour value
2 to form the 1/4 hr segments from the part hours
3 to concantenate the whole hours and part hours back into the desired
duration.

Clearly you will need to experiment with the custom field to create the 1/4
hr segments as my guess is that the rationale will be >0.13 will be 0.25,
<0.13 will be 0, >.63 will be 0.75 and less than 0.63 will be 0.5 etc. This
will be a long formula to develop but could be done with patience.

Hope this helps you as little toward what you are looking for.

Regards

Davidc

 

[Steve House [Project MVP]]

I'll second Dave on this. VBA is an incredibly powerful tool but that power
comes at the price of a steep learning curve and learning it from the ground
up is not a trivial task. People often seem to think that because VBA is
bundled with MS Office products that is is a subset or stripped down version
of the "real" Visual Basic development environment. Actually just the
opposite is true - VBA is a super-set of stand-alone Visual Basic, having
all the functionality of the independent VB language with additional objects
and methods to allow applications to interact with the MS OFfice products.

 

[txtoto]

Thank you both for your help! I really appreciate it!