Trying to convert time in decimals into hours and minutes in excel

NAtsa195 

I think you can't use the time format for that because there is no known hour equal to 155.

So treat the result as text.  =TEXT(INT(I21),"0")&TEXT((I21-INT(I21))*0.6,".00")

That said, as a former HR systems manager myself, I don't follow the logic you're using. I know Excel, so I know how to convert 155.40 to 155.24, but what is the full derivation of the 155.4 in the first place???

I can trace back the formulas; I'm not asking you to do that. I'm asking for an English language policy or procedure explanation of how annual leave is earned for a half-time employee.

Also, if you're expecting to have this used by other people you have a number of spelling mistakes that should be corrected.

In the opening paragraph:

• minites should be minutes
• multiplie should be multiply

Then in cell B22, Annull should be Annual