Time In Lieu Spreadsheet

Hey All,

I have used Google Sheets forever but my new job uses Office and I am struggling with some of Excel's functions.

I'm trying to create a spreadsheet that tracks my time off in lieu (TOIL) so I know where I'm at.

I've created the bare bones of the spreadsheet ash shown in the image but I need help cleaning it up.

Ideally I would like to have all of the time columns (B:H) only have hh:mm format and then all of the 0:00:00 values that haven't been used not to be shown.

In cell L1 I would like it to show the most current level of TOIL, again in hh:mm format.

Is this possible or am I asking too much of Excel?

Thanks in advance.

https://preview.redd.it/c8u5ha2cxszg1.png?width=1001&format=png&auto=webp&s=3985daa3d11541abed488f377c62e375f6ab1224