Civil Engineering Projects
Adding time
If you are working with time that extends the 24-hour format, it is important to change the format of your time entries to the ...
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:
...
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 ...
Returning the date of retirement
Let's work out the exact date our employees will retire using the EDATE function. Our employees reach retirement ...
Converting the month name to a month number
To convert the month name to a month number, proceed as follows:
To return the month name to a ...
Date-Time Functions and Enhancing PivotTable Dashboards
In this chapter, we will explore date functions and look at how to work with time. Here, ...
Using the COUNTIFS statistical function
In our previous edition book, Learn Microsoft Office 2019, we learned all about the COUNTIF function. ...
Using DGET to return a single value
Open the worksheet named Database.xlsx.
Notice that the database is formatted as a data table. Make sure ...
Using the DATEDIF function
DATEDIF is a function that works out the age of the employee to display the year, month, and day in the cell. When ...
Date-Time Functions and Enhancing PivotTable Dashboards
In this chapter, we will explore date functions and look at how to work with ...
Using the COUNTIFS statistical function
In our previous edition book, Learn Microsoft Office 2019, we learned all about the COUNTIF function. ...
Constructing DAVERAGE
We will now work out the average gross margin:
Click into cell G27 on the DATABASE worksheet (using the Database.xlsx ...
