Change it to 72:31 and the sum will work.
Falinaicare
How You have gotten time as 70:91?
What kind of clock there are using?
Time can be over 60 minutes - but minutes with hours can be max 59 - after that it will be hour.
Ps. 71:00 - 59:09 isn't it 11:51? ... or how did You get Your 11:42?
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?
You can use Data Validation to restrict users to enter anything more than 59 for minutes.
Data > Data Validation > Custom > Formula
=MINUTE(A1)<=59
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.
HTH