Adding time Figure 11.29 – TIME worksheet displaying incorrect SUM value Figure 11.30 – Constructing a custom format to display time Figure 11.31 – Total time displayed using the [h]: mm;@ format Figure 11.32 – Adding hours to time Figure 11.33 – Overtime You should now have the skills to confidently work with time in […]
Using Paste Special to convert hours into time Here is a quick and easy method to convert hours into time on the worksheet. Proceed as follows: Figure 11.24 – Paste Special… Here are a few time functions to boost your knowledge: Table 11.2 – Time functions in Excel We will look at a few time
Using Paste Special to convert hours into time Read More »
Working with time When working with time in Excel, we need to ensure that we format cells correctly. This is extremely important as Excel does not display hours over 24 (1 day), seconds greater than 60, or minutes greater than 60. Hours are always fractions of a day in decimal presentation, whereas dates are whole
Returning the date of retirement Let’s work out the exact date our employees will retire using the EDATE function. Our employees reach retirement at 65. Follow the next steps: Now that we know how to calculate the actual date of retirement, there may be instances where we need to how many years until the employee
Returning the date of retirement Read More »
Converting the month name to a month number To convert the month name to a month number, proceed as follows: Figure 11.12 – Converting the month name to the month number Working out the future date from the days specified The WORKDAY function returns the date for a specified number of working days entered from
Converting the month name to a month number Read More »
Date-Time Functions and Enhancing PivotTable Dashboards In this chapter, we will explore date functions and look at how to work with time. Here, we concentrate on DATEDIF(), YEARFRAC(), EDATE(), WORKDAY(), and many more functions to be more productive in the workplace. In addition, a large part of this chapter will explore a host of PivotTable
Date-Time Functions and Enhancing PivotTable Dashboards Read More »
Using the COUNTIFS statistical function In our previous edition book, Learn Microsoft Office 2019, we learned all about the COUNTIF function. Let’s look at an example to recap this function, and explore the COUNTIFS function at the same time. Recapping the COUNTIF function In the next topic, we will expand on prior knowledge and discover
Using the COUNTIFS statistical function Read More »
Using DGET to return a single value Figure 10.26 – Formulating the DGET database function Figure 10.27 – Creating a Product validation rule Let’s look at a few more examples of database functions. Constructing DAVERAGE We will now work out the average gross margin: Figure 10.28 – Formula construction for the average gross margin
Using DGET to return a single value Read More »
