interval between 2 times in Excel

Q16. In Excel, how can I find time interval between 2 times?

For example, I want to find the number of hours that employees have logged in office based on "In Time" and "Out Time".

To do it in Excel, here is the answer:

a) Enter the formula subtracting In Time from Out Time (in the example below, AC3-AB3 since AC3 has Out time and AB3 has In Time).

The value returned is a serial number equivalent of time difference between Out Time and In Time.

excel interval between 2 times

b) To get the result in hours and minutes format, right click on the cell with results, click on Format Cells.

excel excel interval between 2 times

c) Select "Custom" under "Number" tab and then in "type" field, enter "h:mm" to display results in hours and minutes.

excel excel excel interval between 2 times

d) Copy the formula for the rest of the rows.

excel excel excel excel interval between 2 times


You can find similar Excel Questions and Answer hereunder

1) How can I list all files in a folder using VBA?

2) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

3) How can I find number of months that has elapsed given 2 dates?

4) Is there a way I can convert between units of measurement in Excel?

5) How can I find the count of records that meet multiple conditions in my raw data table?

6) How can I protect / unprotect WorkSheet using VBA?

7) Vba delete entire row if contains certain text in Excel

8) I have a large list of clients whose current Age I need to maintain in my database as it influences costs - how can I have Excel display the current age at all times?

9) I track a stock on a daily basis and enter the Open, High, Low and Close values for every trading day. In Excel, how can I automatically get High and Low values for the last 10 trading days?

10) I want a formula to concatenate multiple cell values separated by a line break.

11) In my organization different users have different versions of Excel - how do I check compatibility issues with my WorkBook across versions?

12) How can I generate random numbers between 2 limits?

13) How can I insert a watermark in my Worksheet?

14) I want to add a trend indicator symbol next to my sales data - how can I do that?

15) How can I add interval to dates?