Removing the "d" from the end of a numerical calculation

Is it possible to remove the "d" from the auto calculated columns? For example I have an open date and close date and I want to know how many days it took to close that item.. when it auto calculates that item it adds a "d" at the end of the number. When I export the file to excel to review the data I have to manually remove the "d" so I can average that column.

Find more posts tagged with

Construction

Account and User Management

Comments

Travis

The duration column linked to dependencies will always show the duration type (w, d, h, m, or s).

You have a couple options to strip the duration type out.

First option is to insert a Text/Number column with a formula that references the corresponding Duration cell. This will display just the number.

For example in row 5, add this formula to the new Text/Number column:

=Duration5

Update the cell reference to match the data in your sheet.

The other option is to use the NETWORKDAYS function to calculate the duration. Here's an example:

=NETWORKDAYS([Start Date]6, [End Date]6)

Both these options will display just the numeric value of the duration.

J. Craig Williams

Tonia,

Be aware that the duration value (=Duration5) will be in equivalent days.

4d = 4.

For each sheet, the work hours per days can be configured.

By default, this is 8 hours. But it could be 6 or something else too.

So that means for a typical sheet

4d = 4

8h = 1

Craig

But if the hours per days is 10, then

4d = 4

8h = 0.8