i cant see (h)mm in the custom format

Copper Contributor

Hi 

i am using excel to record my worked hours and sum them to get the total. i can see that the answer was wrong. i clicked on format cell and custom so that i can change it in other to get the right answer. but i cant find (h)mm in but i can only see [t]:mm:ss. 

can you help me?

1 Reply

@Caleb_5050 Use [t]:mm then. I guess t is the abbreviation for hour in your local language setting, like it would be h in English.