Fresh Excel Tips

The worksheet below shows single time parts in each column. Column B contains hours, column C contains minutes, and column D contains seconds. All three columns have to be combined into one time as shown in column E. To do this, use the TIME function. This function returns the decimal number for a particular time. The [...]

When you enter time values in cells, you have to type the colon between the hours and minutes. However, this is unnecessary if you use a custom format. How to create a customized time format: Enter time values without colons and select the cells. From the Format menu, select Cells. Select the Number tab and click on Custom under [...]

In this example, a text string has to be converted to a valid time. Columns A and C contain different start and end times as part of a standardized text string. It is possible to extract the times and convert them to valid time values that can be used as the basis for calculations. To [...]

To wrap text in a cell, you can select Cells from the Format menu, select the Alignment tab, and activate the Wrap text check box. Another way to do this is to type the first row of a cell, then press Alt+Enter, type the next line, and continue as desired. If you want to disable word-wrap, [...]

For this example, we are given a list of products, their sales prices and cost prices and are asked to design a formula that would determine the profitability of eash item, thus giving us a quick and easy insight into which products are the most and least profitable. To achieve this goal, we will need [...]

In this example, we have time in one column (A) and the converted values in minutes in a next column (B). The time is in a hours and minutes format, example 13:56 or 3:10. Here is how we achieve this task. How to convert time in Hours and minutes to minutes only. Open up Microsoft Excel. This [...]

This is a commonly used formula. For this example, we have a list of items and their price in dollars that we would like to convert to Pounds. Dollars will be in Column B and Pounds will be in Column C. We will place the exchange rate in cell C1. For this example, we will [...]

A worksheet lists Names in column A and their birth dates in column B. To calculate the age of these persons in days, first, enter the current date in cell B1 and then perform the following steps: How to Calculate the age of a person in days: Open a worksheet in Excel In this example, we are assuming [...]