Convert duration in excel

[jferree]

Hi,

Is there a way to get excel to show the duration in one unit such as
days.

I copied and pasted from project into excel and now want to get the
duration down to some common unit.

Any ideas?

Jim

 

[Gérard Ducouret]

Hello Jim,

I thinks that the best way is to add a Number(x) field with a formula such
as :
[Duration]/[Minutes by day] (NB : free translation from the French
version...)
This formula gives the duration in days and you can copy or export this
calculated field in Excel.

Hope this helps,

Gérard Ducouret