Excel Formulas to Assign Points Based on Late Time ~ Easy Tutorial!!
Tags: excelformula, excelformulas
Published: 2021-04-30 05:27:12

---
title: Excel Formulas to Assign Points Based on Late Time ~ Easy Tutorial!!
published: true
date: 2021-04-29 14:59:39 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-assign-points-based-on-late-time/
---

Sometimes you need to add the penalty point to students or employees for later submission before the due date or time. How can you calculate them quickly? Here are some cute formulas for you to **assign the points based on late time in Excel**. 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)

[![Add points based on late time](https://geekexcel.com/wp-content/uploads/2021/04/Add-points-based-on-late-time.png)](https://geekexcel.com/excel-formulas-to-assign-points-based-on-late-time/add-points-based-on-late-time/#main)<figcaption id="caption-attachment-34894">Add points based on late time</figcaption>

## General Formula:

- You can use the below formulas to add the penalty points on base time.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)([time](https://geekexcel.com/how-to-use-time-function-in-excel-365/)<[VALUE](https://geekexcel.com/how-to-use-value-function-in-microsoft-excel-2013/)(“0:10”),0,IF(time<VALUE(“0:30”),1,IF(time<VALUE(“0:60”),2,IF(time<VALUE(“2:00”),5,10)))))**

## Syntax Explanations:

- **IF** – In Excel, the **[IF Function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** will help to return one value for a [**TRUE**](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)result, and another for a [**FALSE**](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)result.
- **VALUE** – The **[VALUE function](https://geekexcel.com/how-to-use-value-function-in-microsoft-excel-2013/)** helps to convert text into a numeric value.
- **Time** – In Excel, the **[Time Function](https://geekexcel.com/how-to-use-time-function-in-excel-365/)** to create time on your worksheet
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Let’s get into this article.

- First, we will enter the input values in **Column B**.
- Now we are going to add the penalty points on base time given in **Column G** and **Column H**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-39.png)<figcaption id="caption-attachment-34892">Input Ranges</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formula-31.png)<figcaption id="caption-attachment-34891">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-40.png)<figcaption id="caption-attachment-34893">Result</figcaption>

## Verdict:

Hope you like this article on **how to assign points based on late time in Excel**. If you have any **doubt** regarding this article or have any other **questions** related to Excel, let me know in the **comments** section below. Thank you so much for visiting our site. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas to Add Workdays to Date with Custom Weekends!!](https://geekexcel.com/excel-formulas-to-add-workdays-to-date-with-custom-weekends/)**
- **[Excel Formulas to Add the Business Days to Date ~ Easy Guide!!](https://geekexcel.com/excel-formulas-to-add-the-business-days-to-date-easy-guide/)**
- **[Formulas to Round Prices to End in X.99 ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-round-a-price-to-end-in-x-99/)**