You need to sign in to do that
Don't have an account?
hy.lim1.3897974166558203E12
How to conver number to time formart ( hh:mm:ss) in report?
Hi, I have a simple report and I would like to know how can I convert a number column into time format (hh:mm:ss)?
I have a column (number) that is calculated in mins and I would like to show as time format (hh:mm:ss) in my report instead of whole number.
For example,
- 45 will show 00:45:00,
- 65 will show 01:05:00
is there any formula rules in report can do this?
I have a column (number) that is calculated in mins and I would like to show as time format (hh:mm:ss) in my report instead of whole number.
For example,
- 45 will show 00:45:00,
- 65 will show 01:05:00
is there any formula rules in report can do this?
I found related post on community related to time format reporting.
Might be it can be help you out.
https://success.salesforce.com/answers?id=90630000000guHAAAY
https://success.salesforce.com/answers?id=90630000000gh13AAA
https://success.salesforce.com/answers?id=90630000000goHcAAI
If it would work mark it to help Others :)
Thanks
This is my sample report ->
The 'Email Time' column is actually in mins, as you can see from my sample report above, the Email Time is 100mins and I would like to Avg it and display it as 01:40:00 in my grouping. Please guide me
as a possible workaround, you can create a new formula field / return type text,
IF( FLOOR(Email_Time__c/60)<10, "0"&TEXT(FLOOR(Email_Time__c/60)), TEXT(FLOOR(Email_Time__c/60)))
&":" &
IF( MOD(Email_Time__c,60)<10, "0"& TEXT( MOD(Email_Time__c,60)), TEXT( MOD(Email_Time__c,60))) &":00"
and use this new text field in your report
or create a custom summary formula,
Case.Number__c:AVG/60