Excel Formulas to Find the “First In and Last Out Times”!!
Tags: excelformula, excelformulas
Published: 2020-12-09 08:24:51

---
title: Excel Formulas to Find the “First In and Last Out Times”!!
published: true
date: 2020-12-09 05:34:25 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-the-first-in-and-last-out-times/
---

In this tutorial, we will guide you to learn the simple **formulas used to get the “First in and Last Out times” from the given worksheet in Excel Office 365**. Let’s get started!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Jump To:

- [**General Formula**](#1)
- [**Syntax Explanations**](#2)
- [**Examples**](#3)
- [**Closure**](#4)

## General Formula:

- To find the First in, last out times from a worksheet data in Excel, use the below formulas.

### Formulas to get First in times:

**=[MINIFS](https://geekexcel.com/how-to-use-excel-minifs-function-in-office-365-with-examples/)(times,names,name,actions,”in”)**

### Formulas to get the Last out times:

**=[MAXIFS](https://geekexcel.com/how-to-use-excel-maxifs-function-in-office-365-with-examples/)(times,names,name,actions,”out”)**

## Syntax Explanations:

- **MINIFS** – In Excel, the **[MINIFS function](https://geekexcel.com/how-to-use-excel-minifs-function-in-office-365-with-examples/)** returns the minimum value from the given input values specified by one or two conditions.
- **MAXIFS** – The **[MAXIFS Function](https://geekexcel.com/how-to-use-excel-maxifs-function-in-office-365-with-examples/)** returns the largest numeric value from the range of input values based on the given condition or criteria.
- **Times** – It represents the input times from the given worksheet.
- **Names** – It is the input names.
- **Actions** – It is the specific actions of the given inputs.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Examples:

- Let’s see some examples to understand these formulas.

### Example to find First in times:

- Now we are going to see how to get the first in times from the given worksheet.
- Here, we will give the input ranges in **Column B** , **Column C** , and **Column D**.
- Then, enter the given First in Formula in the formula bar section.
- Finally, it will display the result in **Cell G3**.

![Example to find first in times](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/First-in-example.png)<figcaption id="caption-attachment-19110">Example to find first in times</figcaption>

### Example to find Last out times:

- Let’s consider the below example to find the Last Out times from the given worksheet.
- Here, we will give the input ranges in **Column B** , **Column C** , and **Column D**.
- Then, enter the Last Out Formula in the selected field.
- Finally, it will display the result in **Cell G3**.

![Example to find last out times](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/last-out-example.png)<figcaption id="caption-attachment-19111">Example to find last out times</figcaption>

## Closure:

From this guide, you can get some clarification on the **formulas used to find the “First In and Last Out Times” from a given worksheet in Excel Office 365**. Hope you like this article. Kindly, share your **feedback** in the below **comment** section. To know further updates keep in touch with our website **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas to Find Pass or Fail Using COUNTIF Function!!](https://geekexcel.com/excel-formulas-to-find-pass-or-fail-using-countif-function/)**
- **[Excel Formulas to Calculate the Average of Numbers!!](https://geekexcel.com/wp-admin/post.php?post=18806&action=edit)**

### Video Tutorial:

<!--[if lt IE 9]><script>document.createElement('video');</script><![endif]--><video id="video-19103-1" width="770" height="436" loop="1" autoplay="1" preload="metadata" controls="controls"><source type="video/mp4" src="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1MaeSipnYl.mp4?_=1"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1MaeSipnYl.mp4">https://geekexcel.com/wp-content/uploads/2020/12/1MaeSipnYl.mp4</a></video>