In this article, we will learn how to calculate military time intervals. We will use the “Text” and “DOLLARDE” functions in Microsoft Excel 2010.
TEXT: -This function is used to convert a value to text in a specific number format.
Syntax of “TEXT” function: =TEXT (Value, format_text)
For Example: -
DOLLARDE: -This function is used to convert a dollar price, which is expressed as a fraction, into a dollar price reflecting as a decimal number.
Syntax of “DOLLARDE” function: =DOLLARDE (fractional_dollar, fraction)
Let’s take an example to understand how we can calculate military time intervals.
We have data in the range A1:B10. Both the columns contain the interval timings, and formatted in military style (hhmm). Now, we want to return the interval timings.
To find the interval in between pairs of times when they are formatted in Military style (hhmm), follow below given formula:-
There is another formula to return the same result. To apply that formula, follow below given steps:-
These are the ways by which we can calculate the interval timings from In and Out timings which are formatted as military timings.
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.