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

Tonia Thomas

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.

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