hours

[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
=IF(C3="";0;IF(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

 

[CWatts]

To put the numbers in a text string you'll have to format them with the TEXT formula.

For example, replace your C2*24 with TEXT(C2,"h:mm")