How to Extract Hours/Minutes/Seconds from Time in Excel

Date:2021-5-10 Author:Sandra

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?

How to Extract Hours/Minutes/Seconds from Time in Excel

Hour

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

How to Extract Hours/Minutes/Seconds from Time in Excel

Minute

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

How to Extract Hours/Minutes/Seconds from Time in Excel

Second

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

How to Extract Hours/Minutes/Seconds from Time in Excel

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.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *