# Learn How to Get First In Last Out Times in Microsoft Excel

Written by | 0 Comments | 294 Views

In this article, you will learn how to evaluate things with MIN and MAX functions in Microsoft Excel using a single/combination(s) of functions. You will also know to Get First In Last Out Times and see the generic formula.

Learn How to Get First In Last Out Times in Microsoft Excel

The main purpose of this formula is to get "first in, last out" times from timesheet data. Here we will learn how to get first in and last out times in the given data range in the workbook in Microsoft Excel. That implies, with the help of a formula based on the MINIFS, and MAXIFS functions you can able to get "first in, last out" times from timesheet data. So, with the help of this formula, you can able to get the first in and last our times in the given data range in the workbook in Microsoft Excel.

General Formula to Get First In Last Out Times

=MINIFS(times,names,name,actions,action)

The Explanation to Get First In Last Out Times

So we know that with the help of the given formula above you can able to get "first in, last out" times from timesheet data. Here we will learn how to get first in and last out times in the given data range in the workbook in Microsoft Excel. As we know the MINIFS function is used to return minimum values in a range based on one or more criteria. here, the range we are extracting a minimum value from is the E column named "times". MINIFS function then returns the earliest or minimum time where the name is "Max" and the action is "in". In a similar way with the MAXIFS function, the "last out" time is calculated. So now you have learned how to get first in and last out times in the given data range in the workbook in Microsoft Excel.