Forum Discussion
Trying to convert time in decimals into hours and minutes in excel
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
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
mathetes, thank you very much for your help. I am on the right way now. Still figuring out when outcome is negative. I am just a moderate user but more advanced then the rest of our team. I am trying to make it easier for them. Your help is greatly appreciated.
Regarding the spellings mistakes, I will proof read it before I am going to distribute the spreadsheet. But as Dutch native they do forgive me when I make spellings mistakes 😉
Wishing you a nice weekend,
With kind regards,
Natascha van der Pol