INT Function

How to Convert Week Number to Date in Excel (2 Suitable Methods)

In Microsoft Excel, working with week and date is one of the crucial tasks. You will find yourself in a lot of situations where you will have to find ...

How to Convert Single Columns to Rows in Excel with Formulas

In this article, I will show how to convert single columns to rows using excel formulas. Basically, when we copy data from any word editor to excel, ...

How to Convert Multiple Columns into a Single Row in Excel (2 Ways)

In Microsoft Excel, converting multiple columns to a single row is one of the familiar tasks. You will find yourself in a lot of situations where you ...

How to Subtract Date and Time in Excel (6 Easy Ways)

Very often we need to subtract two dates in our day-to-day operation. When we calculate age or duration typically we subtract two dates. In this ...

Calculate Elapsed Time Between Two Dates in Excel (5 Methods)

Dates and Times in excel are considered as integer and fractional numbers respectively. We can calculate the elapsed time between two dates in excel. ...

How to Add Hours to Time in Excel (8 Quick Ways)

If you want to add hours to time in Excel easily, then you can follow this article for knowing various ways to do this job. So, let’s get into the ...

Excel Formula To Calculate Time Worked

In Microsoft Excel, working with time is one of the familiar tasks. You will find yourself in a lot of situations where you will have to calculate ...

How to Subtract Time in Excel (7 Quick Methods)

There are many times we need to subtract time in our Excel worksheet. We often subtract time to find elapsed time. In this article, we will see ...

How to Use VBA Int Function in Excel ( 3 Examples)

The Int function in Microsoft Excel returns the integer part of a value. The VBA Int is a built-in function in Excel. In Excel, it can be used as a ...

44 Mathematical Functions in Excel (Download Free PDF)

Microsoft Excel has plenty of mathematical functions that help perform various mathematical operations. In this article, you will get to know 44 ...

Excel Current Time Formula (7 Suitable Examples)

It’s always handy to be able to insert current time using Excel current time formula or keyboard shortcuts in cells. In this article, we demonstrate ...

How to Calculate Time in Excel (16 Possible Ways)

It is possible to calculate time using arithmetic operations along with excel functions because in Excel dates and times are stored as numbers in the ...

How to Calculate Time Difference in Excel (13 Ways)

If you are looking for some of the easiest ways to calculate the time difference in Excel, then you are in the right place. Let’s dive into the main ...

Calculate Hours Between Two Times in Excel (6 Methods)

If you have two times in two different cells in Excel and want to calculate the difference in hours, then you are in the right place. We will show ...

How to Convert Timestamp to Date in Excel (7 Easy Ways)

A timestamp is a sequence of characters used to specify the date and time of a day. Of course, any specific time or event can be expressed in ...

ExcelDemy
Logo