I can get a report of all activities for a given account, but duration
is in mixed units and it's not clear how this can be totalled.

RE: Any clue how to standardize duration units? by FrankLee

FrankLee
Thu Aug 09 23:40:01 CDT 2007

2 practical ways to try:

1. export to excel and create a column with formula to convert and
standarize the value

2. create a srs report to exactly the way you want


Good luck.




Frank Lee, Microsoft CRM MVP
http://microsoft-crm.spaces.live.com
http://www.workopia.com/Links.htm



"michaeloboyle@michaeloboyle.com" wrote:

> I can get a report of all activities for a given account, but duration
> is in mixed units and it's not clear how this can be totalled.
>
>

Re: Any clue how to standardize duration units? by michaeloboyle

michaeloboyle
Thu Aug 16 15:56:08 CDT 2007

On Aug 10, 12:40 am, Frank Lee <Frank...@discussions.microsoft.com>
wrote:
> 2 practical ways to try:
>
> 1. export to excel and create a column with formula to convert and
> standarize the value
>
> 2. create a srs report to exactly the way you want
>
> Good luck.
>
> Frank Lee, Microsoft CRM MVPhttp://microsoft-crm.spaces.live.comhttp://www.workopia.com/Links.htm
>
>
>
> "michaelobo...@michaeloboyle.com" wrote:
> > I can get a report of all activities for a given account, but duration
> > is in mixed units and it's not clear how this can be totalled.- Hide quoted text -
>
> - Show quoted text -

Thanks for the reply. Any chance you have the conversion formula
handy?


Re: Any clue how to standardize duration units? by michaeloboyle

michaeloboyle
Thu Aug 16 16:07:51 CDT 2007

On Aug 16, 4:56 pm, michaelobo...@michaeloboyle.com wrote:
> On Aug 10, 12:40 am, Frank Lee <Frank...@discussions.microsoft.com>
> wrote:
>
>
>
> > 2 practical ways to try:
>
> > 1. export to excel and create a column with formula to convert and
> > standarize the value
>
> > 2. create a srs report to exactly the way you want
>
> > Good luck.
>
> > Frank Lee, Microsoft CRM MVPhttp://microsoft-crm.spaces.live.comhttp://www.workopia.com/Links.htm
>
> > "michaelobo...@michaeloboyle.com" wrote:
> > > I can get a report of all activities for a given account, but duration
> > > is in mixed units and it's not clear how this can be totalled.- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks for the reply. Any chance you have the conversion formula
> handy?

Scratch that. I've found one solution.

When exporting to Excel, selecting "Dynamic worksheet" renders the
duration in minutes.