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?
Enter ‘=hour (B4)’ in cell C4 and press Enter key.
Enter ‘minute(B4)’ in cell D4 and press Enter key.
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.