How to work with times
In this video we'll look at functions that will let you extract the hour, minute, and second values from a time, as well as a function called TIME that will let you put them together again...
Dave Bruns
How to create date and time series with formulas
Although you can use Excel's AutoFill feature to fill in a series of dates and times, you can also do the same thing with formulas. The advantage of using a formula is that you can easily change the starting value and generate a new series...
How to calculate the number of days between dates
In this video we'll look at several ways to calculate the number of days between dates. ...
How to calculate years and months between dates
In this video we'll look at how to calculate the number of years or months between dates using a function called DATEDIF and a function called YEARFRAC. The DATEDIF function is a "compatibility" function that originated from Lotus 1-2-3. ...
CONVERT Function
The CONVERT function converts a number in one measurement system to another. For example, you can use CONVERT to convert feet into meters, pounds into kilograms, gallons into liters, and for many other unit conversions.
Examples
The formulas below use the CONVERT function to...Read more
DATEDIF Function
The DATEDIF function is designed to calculate the difference between two date values in years, months, or days. The result from DATEDIF is a number that corresponds to the time unit requested. DATEDIF is a versatile function that can be used in financial analysis, project planning, age...Read more
SIN Function
The SIN function returns the sine of an angle provided in radians. In geometric terms, the sine of an angle returns the ratio of a right triangle's opposite side over its hypotenuse. For example, the sine of PI()/6 radians (30°) returns the ratio 0.5.
...Read more
COS Function
The COS function returns the cosine of an angle provided in radians. In geometric terms, the cosine of an angle returns the ratio of a right triangle's adjacent side over its hypotenuse. For example, the cosine of PI()/6 radians (30°) returns the ratio 0.866.
...Read more
SIGN Function
The SIGN function returns the sign of a number as +1, -1 or 0. If number is positive, SIGN returns 1. If number is negative, sign returns -1. If number is zero, SIGN returns 0.
The SIGN function takes one argument, number, which must be a numeric value...Read more