timpoynter
asked on
CRM 4 - How to change the time format from minutes to hours\days
Hi,
In CRM 4, you are able to create contract lines and apply allotted time purchased to them, the allotment time is in minutes, so all reports and every thing else that is linked with them is also in minutes. Is there a way to have the display show hours+mins instead of just minutes.
In CRM 4, you are able to create contract lines and apply allotted time purchased to them, the allotment time is in minutes, so all reports and every thing else that is linked with them is also in minutes. Is there a way to have the display show hours+mins instead of just minutes.
Are you talking about the Allotments Used and Allotments Remaining? These are the out of the box attributes, and are of type Int. Perhaps one of these attributes has been customized so that the label is Allotted time in minutes?
If it's just a matter of your reports showing hrs + minutes instead of just minutes, then I would leave the attribute alone in CRM but adjust the formatting of the attribute value in the report. You can use an expression in the report to adjust the way it is shown. For instance if your attribute were AllottedMins your expression could be:
IIF(Fields!AllottedMins.Va lue < 60, Fields!AllottedMins.Value + "Mins", (Fields!AllottedMins.Value / 60) + " Hrs" + MOD(Fields!AllottedMins.Va lue / 60) + " Mins")
This expression (check the syntax because I'm going from memory here...) would return "59 Mins" or "1 Hrs 23 Mins" for example depending on if the value is less than 60 or not...
If it's just a matter of your reports showing hrs + minutes instead of just minutes, then I would leave the attribute alone in CRM but adjust the formatting of the attribute value in the report. You can use an expression in the report to adjust the way it is shown. For instance if your attribute were AllottedMins your expression could be:
IIF(Fields!AllottedMins.Va
This expression (check the syntax because I'm going from memory here...) would return "59 Mins" or "1 Hrs 23 Mins" for example depending on if the value is less than 60 or not...
ASKER
Hello processguru,
Yes they are Allotments Used and Allotments Remaining, but I have checked the attributed and they are geyed out, I assume as they are system entitys they are not editable, is that correct?
The advice for the report was very valuable, Thankyou.
Yes they are Allotments Used and Allotments Remaining, but I have checked the attributed and they are geyed out, I assume as they are system entitys they are not editable, is that correct?
The advice for the report was very valuable, Thankyou.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oh, and don't forget to call your OnCrmPagLoad() function too...
1. You can create two fields hrs and minutes
2. write onchange event for both the field which will calculate values in the total minutes.
3. You can change the assosciated view ( related contact lines to display hours and minutes)
4. You have to change reports manually to do this
Regards
Rakesh