Reporting : Sum time, format

[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

[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

[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

[alexa]

Thank you for the reply.

Could you please let us know what are the types of the columns TicketTask.Logwork and TicketTask.CreationDate?

[nusa]

Hi,

TicketTask.Logwork : INT
TicketTask.CreationDate : datime

TicketTask.CreationDate is not important, I make a sum of TicketTask.Logwork

Nusa

[nusa]

I sole vmy problem :

Code: Select all

CONVERT (TIME(0), DATEADD(SECOND, TicketTask.Logwork, 0)) as 'hh:mm:ss'

Nusa

[alexa]

Thank you for updating us on this issue.