Calendar Days instead of Work Days

[Laz]

I have a completed plan with all the task durations in days (work days). I
need to generate reports and schedules views in calendar days.

Is there a method to do change from days to edays in the reports and task
durations?

 

[JulieS]

Hello Laz,

You could add a custom duration formula and calculate the differences
between the Start and Finish date using a custom calendar which had 7 working
days per week.

Create a custom calendar (Tools > Change Working Time > New) and set all
Saturdays and Sundays to working days. In the formula below, I assumed a name
for the custom calendar of "7Day"

Add a custom Duration field (Duration1 for example) and add the following
formula:
ProjDateDiff([Start],[Finish],"7Day")

The formula will calculate the difference between the start and finish dates
using the custom calendar.

I hope this helps. Let us know how you get along.

Julie

 

[Laz]

Julie ..... I did as you suggested, it works for the non-summary tasks, but
not for the summary tasks. How can I get the summary tasks to also show the
calendar days? The summary task are critical in reporting!!!

Thanks for your time,
Laz

Hello Laz,

You could add a custom duration formula and calculate the differences
between the Start and Finish date using a custom calendar which had 7 working
days per week.

Create a custom calendar (Tools > Change Working Time > New) and set all
Saturdays and Sundays to working days. In the formula below, I assumed a name
for the custom calendar of "7Day"

Add a custom Duration field (Duration1 for example) and add the following
formula:
ProjDateDiff([Start],[Finish],"7Day")

The formula will calculate the difference between the start and finish dates
using the custom calendar.

I hope this helps. Let us know how you get along.

Julie

I have a completed plan with all the task durations in days (work days). I
need to generate reports and schedules views in calendar days.

Is there a method to do change from days to edays in the reports and task
durations?

 

[JulieS]

Hi Laz,

You need to set the custom field to calculate for the summary rows. Go
back to Customize Fields and select "Use formula" under the section
"Calculation for task and group summary rows."

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Julie ..... I did as you suggested, it works for the non-summary
tasks, but
not for the summary tasks. How can I get the summary tasks to also
show the
calendar days? The summary task are critical in reporting!!!

Thanks for your time,
Laz

Hello Laz,

You could add a custom duration formula and calculate the differences
between the Start and Finish date using a custom calendar which had 7
working
days per week.

Create a custom calendar (Tools > Change Working Time > New) and set
all
Saturdays and Sundays to working days. In the formula below, I
assumed a name
for the custom calendar of "7Day"

Add a custom Duration field (Duration1 for example) and add the
following
formula:
ProjDateDiff([Start],[Finish],"7Day")

The formula will calculate the difference between the start and
finish dates
using the custom calendar.

I hope this helps. Let us know how you get along.

Julie

I have a completed plan with all the task durations in days (work
days). I
need to generate reports and schedules views in calendar days.

Is there a method to do change from days to edays in the reports
and task
durations?

 

[Laz]

Julie .....
Thank you very much.
The column and formuls worked well.
I should have remembered to set to calc for the summary rows.
Thanks again,
Laz

Hi Laz,

You need to set the custom field to calculate for the summary rows. Go
back to Customize Fields and select "Use formula" under the section
"Calculation for task and group summary rows."

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Julie ..... I did as you suggested, it works for the non-summary
tasks, but
not for the summary tasks. How can I get the summary tasks to also
show the
calendar days? The summary task are critical in reporting!!!

Thanks for your time,
Laz

Hello Laz,

You could add a custom duration formula and calculate the differences
between the Start and Finish date using a custom calendar which had 7
working
days per week.

Create a custom calendar (Tools > Change Working Time > New) and set
all
Saturdays and Sundays to working days. In the formula below, I
assumed a name
for the custom calendar of "7Day"

Add a custom Duration field (Duration1 for example) and add the
following
formula:
ProjDateDiff([Start],[Finish],"7Day")

The formula will calculate the difference between the start and
finish dates
using the custom calendar.

I hope this helps. Let us know how you get along.

Julie

:

I have a completed plan with all the task durations in days (work
days). I
need to generate reports and schedules views in calendar days.

Is there a method to do change from days to edays in the reports
and task
durations?

 

[JulieS]

You're welcome Laz and thanks for the feedback.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Julie .....
Thank you very much.
The column and formuls worked well.
I should have remembered to set to calc for the summary rows.
Thanks again,
Laz

Hi Laz,

You need to set the custom field to calculate for the summary rows.
Go
back to Customize Fields and select "Use formula" under the section
"Calculation for task and group summary rows."

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

Julie ..... I did as you suggested, it works for the non-summary
tasks, but
not for the summary tasks. How can I get the summary tasks to also
show the
calendar days? The summary task are critical in reporting!!!

Thanks for your time,
Laz

:

Hello Laz,

You could add a custom duration formula and calculate the
differences
between the Start and Finish date using a custom calendar which
had 7
working
days per week.

Create a custom calendar (Tools > Change Working Time > New) and
set
all
Saturdays and Sundays to working days. In the formula below, I
assumed a name
for the custom calendar of "7Day"

Add a custom Duration field (Duration1 for example) and add the
following
formula:
ProjDateDiff([Start],[Finish],"7Day")

The formula will calculate the difference between the start and
finish dates
using the custom calendar.

I hope this helps. Let us know how you get along.

Julie

:

I have a completed plan with all the task durations in days
(work
days). I
need to generate reports and schedules views in calendar days.

Is there a method to do change from days to edays in the reports
and task
durations?