Convert Julian Date to a Calendar Date in Microsoft Excel

In this article you’ll learn, how to convert a Julian date to a calendar date. What is Julian date? Julian date calendar was introduced by Jul...

Calculating Military Time Intervals in Microsoft Excel 2010

In this article, we will learn how to calculate military time intervals. We will use the “Text” and “DOLLARDE” functions in Microsoft Excel 20...

Rounding Times Down to a Specified Time Increment in Microsoft Excel 2010

In this article, we will learn how toround the times down to a specified time increment.We will use a combination of“TIME”, “HOUR”, “MINUTE...

Subtracting Times in Microsoft Excel

To determine which of two values is the earliest and then Excel subtracting time  accordingly. We will use If function to create subtracting time cal...

Determining whether a Person Worked in a Full Or Partial Shift in Excel 2010

In this article, we will learn how to determine whether a person worked a full or partial shift. While preparing attendance report, you want a form...

Determining which Quarter a Specified Date Corresponds To in Excel 2010

In this article, we will learn how to determine in which quarter a specified date corresponds. While working on reports, you have some dates & ...

Avoiding Negative Values when Calculating the Number of Days between Two Dates in Microsoft Excel 2010

In this article you’ll learn, how to avoid negative values while calculating the number of days between two dates. We’ll use MIN, MAX and DATE fun...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube