When we are making an Excel table, we need to keep all the time in the table only in hours instead of minutes and seconds. So what should we do in this situations?

Hour

Enter ‘=hour (B4)’ in cell C4 and press Enter key.

Minute

Enter ‘minute(B4)’ in cell D4 and press Enter key.

Second

Enter ‘second(B4)’ in cell E4 and press Enter key.

So you can extract not only hour part, but also minute or second part of time in this manner. It’s really simple and effective, hope this can be helpful to you.