Thanks vletm for highlighting. You are correct as it is my typo error. The answer is 11:51.
Do you mean that I have to use the function TEXT? Sorry as I don;t get your meaning.FYI avoid applying manual alignment to columns. As text values align left and numbers align right, manual alignment will hide that fact and you will have trouble discovering errors. (if any)
No. XL "naturally" aligns text values left and number values right in cells. Makes them easy to recognize ( unless you manually aligned as in your example sheet)Do you mean that I have to use the function TEXT? Sorry as I don;t get your meaning.
You can use Data Validation to restrict users to enter anything more than 59 for minutes.vletm
Thank you very much for your explanation.
Can I ask is there a conditional formatting to tell to the other staffs that, the time of 70:91 is invalid due to more than 60 minutes?
abhi0300You can use Data Validation to restrict users to enter anything more than 59 for minutes.
Data > Data Validation > Custom > Formula
A1 is the cell where user is entering that time. Copy this cell once you've tested it, select the target range, Paste Special > Validation.