Page 1 of 1
Reporting : Sum time, format
Posted: Tue 14 Feb 2017 11:36
by nusa
Hi,
I'm french people. I wanted to create a reporting. I sum a different time on min. My result is not good.
For ewample I've 200 min. I wanted to see : 3hrs 20 min on my report.
is'it possible?
Thank's.
Nusa
Re: Reporting : Sum time, format
Posted: Tue 14 Feb 2017 13:33
by alexa
Could you please provide us the report file and the CREATE definitions of the objects that are present in the report? Screenshots or video would be also of help.
You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom
Re: Reporting : Sum time, format
Posted: Wed 15 Feb 2017 08:20
by nusa
Hi,
On my Report I've :
https://cl.ly/1i0H2D0t0U3w
136 is in minutes : 136 minutes.
i wanted to see 2h 16 min.
is it possible?
Nusa
Re: Reporting : Sum time, format
Posted: Wed 15 Feb 2017 12:05
by alexa
Thank you for the reply.
Could you please let us know what are the types of the columns TicketTask.Logwork and TicketTask.CreationDate?
Re: Reporting : Sum time, format
Posted: Wed 15 Feb 2017 13:45
by nusa
Hi,
TicketTask.Logwork : INT
TicketTask.CreationDate : datime
TicketTask.CreationDate is not important, I make a sum of TicketTask.Logwork
Nusa
Re: Reporting : Sum time, format
Posted: Thu 16 Feb 2017 16:30
by nusa
I sole vmy problem :
Code: Select all
CONVERT (TIME(0), DATEADD(SECOND, TicketTask.Logwork, 0)) as 'hh:mm:ss'
Nusa
Re: Reporting : Sum time, format
Posted: Fri 17 Feb 2017 12:39
by alexa
Thank you for updating us on this issue.