how to convert time from second to Hours in report
Naveen Tyagi (197●78●152)
| asked Jan 15 '16, 5:33 a.m.
edited Jan 15 '16, 5:41 a.m. by Ralph Schoon (63.4k●3●36●46)
I am getting time(Actual/Planned ) values in Seconds in report. is there any way to convert it into hours ? I'm using report builder. Thanks in Advance.
|
Accepted answer
How about like this? DOUBLE(T1.ACTUAL_WORK/3600) and DOUBLE(T1.PLANNED_WORK/3600)
Rosa Naranjo selected this answer as the correct answer
Comments I'm trying to do the same thing, and I've not been able to get the calculations to work properly. Any help on this would be greatly appreciated. The bold "actual work and planned work" is what I need to divide by 3600 to turn into hours.
SELECT DISTINCT T1.REFERENCE_ID,
T2.FULL_NAME,
T1.NAME,
T1.REQUEST_TYPE,
T1.CREATION_DATE,
T1.DUE_DATE,
T1.REQUEST_CATEGORY_NAME,
T1.ITERATION_NAME,
T1.FOUND_IN_RELEASE_NAME,
T1.ACTUAL_WORK,
T1.PLANNED_WORK,
T1.REQUEST_STATE,
T1.REC_DATETIME
FROM RIDW.VW_REQUEST T1
INNER JOIN RIDW.VW_RESOURCE T2
ON T2.RESOURCE_ID=T1.OWNER_ID
WHERE T1.PROJECT_ID = 11 AND
( T1.REQUEST_TYPE = 'Change Request' AND
(T1.REQUEST_STATE = 'Analysis' OR T1.REQUEST_STATE = 'Approved' OR T1.REQUEST_STATE = 'COR Approval' OR T1.REQUEST_STATE = 'Closed' OR T1.REQUEST_STATE = 'Completed' OR T1.REQUEST_STATE = 'In Progress' OR T1.REQUEST_STATE = 'New' OR T1.REQUEST_STATE = 'Verified' ) AND
DAYS(CURRENT_TIMESTAMP) - DAYS(T1.REC_DATETIME) <= 7
) AND
(T1.ISSOFTDELETED = 0) ORDER BY T2.FULL_NAME asc
Hello
Tarik Mahfoudi
commented May 04 '17, 5:01 p.m.
JRS 5.0.2 and CLM 5.0.2 This worked:
INT(T1.ACTUAL_WORK/3600) as TimeSpent,
|
One other answer
For that you will have to drop down into the Advanced section of the report builder and edit the SQL for the report.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.