I have a field called WorkingDaysDiff It stores the number as hours but I need it broken out into mm dd hh mm ss so I can use this as a metric for reporting.

This code currently works displaying a whole number in the WorkingDaysDiff column there are also some null values.

Select Step1.TicketName,
Step1.CreateDate,
Step1.AuthorizeDate,
Step1.AssignDate,
Step1.WIPDate,
Step1.ProductionDate,
Step1.ReviewDate,
Step1.CloseDate,
Step1.CurrentState,
Step1.CurrentQueue,
Step1.TicketType,
Step1.TicketCategory,
Step1.Project,
Step1.ProjectDescription,
Step1.ProjectDate,
DateDiff(ReviewDate,CreateDate) AS WorkingDaysDiff,
DateDiff(ReviewDate,CreateDate) AS WorkingHoursDiff
-- DateDiff(dd,d,hh,mi,n Step1.ReviewDate,Step1.CreateDate) AS WorkingDaysDiff
FROM (Select t.id As TicketID,
# t.tn As TicketNumber,
Convert(t.tn, Unsigned) As TicketNumber,
t.title As TicketName,

(Select create_time
From ticket_history
Where ticket_id = t.id
And history_type_id = 1)
As CreateDate,

(Select Min(create_time)
From ticket_history
Where ticket_id = t.id
And state_id = 13)
As AuthorizeDate,

(Select Min(create_time)
From ticket_history
Where ticket_id = t.id
And queue_id In (5,6,7,12,13,14,17,18,19,22,23,27,31,32,42,43) )
As AssignDate,

(Select Min(create_time)
From ticket_history
Where ticket_id = t.id
# And state_id = 14 )
And state_id In (14,19) )
As WIPDate,

(Select Max(create_time)
From ticket_history
Where ticket_id = t.id
And state_id = 18 )
# And state_id In (17,18,23,25,26) )
# Or queue_id In (24,25,33,34,35,36,49) )
As ProductionDate,

(Select Min(create_time)
From ticket_history
Where ticket_id = t.id
And state_id In (10,16,27)
And create_time >= ProductionDate)
As ReviewDate,

(Select Min(create_time)
From ticket_history
Where ticket_id = t.id
And state_id In (2,3,5,7,8,9,22) )
# And create_time >= ProductionDate)
As CloseDate,

s.name As CurrentState,
q.name As CurrentQueue,
tt.name As TicketType,

Case
When t.type_id In (2,3,4,5,6,8,11,12,15,16,17) Then 'Networking'
When t.type_id = 14
Or (t.type_id In (7,10,13)
And (Select Min(queue_id)
From ticket_history
Where ticket_id = t.id
And create_time < ProductionDate
And queue_id In (6,17,18,19,31))
Is Not Null) Then 'Development'
When t.type_id In (7,10,13) Then 'Networking'
When t.type_id = 9
Or (Select Min(queue_id)
From ticket_history
Where ticket_id = t.id
And create_time < ProductionDate
And queue_id In (7,22,23))
Is Not Null Then 'Business Development'
Else 'Other'
End As TicketCategory,

t.freekey16 as Project,
t.freetext16 as ProjectDescription,
t.freetime6 as ProjectDate

From ticket t, ticket_type tt,
ticket_state s, queue q

#Where tt.id = t.type_id
# And q.id = t.queue_id
# And s.id = t.ticket_state_id
# And Week(Date(t.create_time)) < Week(Curdate())

#Where Week(Date(t.create_time)) < Week(Curdate())
# And Year(Date(t.create_time)) <= Year(Curdate())
Where Date(t.create_time) <
Date_Add(Curdate(), Interval(1-DayofWeek(CurDate())) Day)
# And Date(t.create_time) >
# Date_Sub(Curdate(), Interval(79) Week)
And tt.id = t.type_id
And q.id = t.queue_id
And s.id = t.ticket_state_id

# And t.id In (17,743,770,771,959)
# And t.id In (17,736,737,738,739,740,741,742,743,744,745,
# 746,747,748,749,750,770,771,959)

Order By t.id)As Step1 Order By 1;

How do I Cast the WorkingDaysDiff into the abovementioned format?

I am relatively new to MySQL. I have been using SQL for a while.

Thanks in advance for any and all help!