time

[kuzna]

A2- List from 1 to 20 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
A3 – MAINTENANCE TEAM<o></o>
C2- 23:10 [h]:mm ……………. Time Worked <o></o>
B2. 123:45 [h]: mm ------------Max Time
=SE(C3="";0;SE(A2=" ";0;C3&"HAS WORKED "&C2*24&" OF "&B2*24&""))

UNFORTUNATELY ITS SHOWS ME AS

MAINTENANCE TEAM HAS WORKED 23,1666 OF 123,75 HRS,

i want it to show the exactly time as:

MAINTENANCE TEAM HAS WORKED 23:10 OF 123:45 HRS,

Please help me

 

[Robert Mika]

In this case why do you multiply this bit:

"HAS WORKED "&C2*24&" OF "&B2*24&""