Function: HOUR

Function: HOUR

The Excel Hour function is a Date & Time formula that parses and returns the hour value from a time value. The return value is an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.). In this guide, we’re going to show you how to use the Excel HOUR function and...
How to create bullet points in Excel (•)

How to create bullet points in Excel (•)

Excel is not a word processor software, but you may still want to list things in various parts of your workbooks. Bullet points are great for creating lists, as its the universal indicator of an unordered list. Here, we’re going to cover 4 different ways to...
How to concatenate strings in Excel

How to concatenate strings in Excel

Although Excel tasks typically involve working with numbers, you can also manipulate text strings by concatenating them. In this guide, we’re going to show you how to concatenate strings in Excel using the ampersand character and also with the help of other...
How to round numbers in Excel

How to round numbers in Excel

Rounding numbers is a crucial element of creating legible and easy-to-use spreadsheet tools. Excel offers a few methods to do this, including a formula approach and the number formatting feature. In this guide, we’re going to show you how to round numbers in...

How to convert pounds to kg, and vice versa

Converting units can be time consuming when you rely on a separate tool or website to do it. In this guide, we are going to show you how to convert pounds to kg and kg to pounds. Download Workbook Manual approach The first approach we are going to show you is doing...