Excel
Excel: Convert Decimal Time to Hours & Minutes
You can use the following formula to convert a decimal time to hours and minutes in Excel:
=TEXT(B2/24, "h:mm")
This will convert the decimal time in...
Descriptive Statistics in Excel
How to Find Y-Intercept of a Graph in Excel
The y-intercept of a graph represents the point where a line crosses the y-axis when x is equal to zero.
To find the y-intercept of...
Excel
How to Create a Correlation Graph in Excel (With Example)
Often you may want to create a graph in Excel that allows you to visualize the correlation between two variables.
This tutorial provides a step-by-step...
Excel
How to Graph Three Variables in Excel (With Example)
There are two common ways to create a graph with three variables in Excel:
1. Create a Line Graph with Three Lines
2. Create a Bar...
Excel
How to Filter a Chart in Excel (With Example)
Often you may want to filter a chart in Excel to only display a subset of the original data.
Fortunately this is easy to do...
Excel
Excel: How to Calculate Years Between Two Dates
You can use the following formulas to calculate the number of years between two dates in Excel:
Formula 1: Calculate Full Years Between Two Dates
=INT(YEARFRAC(A2,B2))
Formula...
Excel
How to Get First Day of Month in Excel (With Examples)
You can use one of the following formulas to get the first day of the month for a date in Excel:
Formula 1: Use DAY()...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read