CODEWITHSUNDEEP
excelexcel-formula
MaxMiak
MaxMiak

Reputation: 197

Minutes difference between two timestamps in Excel

I have two timestamps as below, I would like to find the difference in minutes:

end time = 2020-08-12T10:25:50.775+04:30

start time= 2020-08-12T10:50:50.775+04:30

I want to find the difference end_time - start_time in minutes in Excel. Thanks in advance.

Upvotes: 0

Views: 548

Answers (1)

Xlsx
Xlsx

Reputation: 175

The format is not read as a datetime in excel. Assuming the time is in cell A1, you can apply this formula =DATEVALUE(LEFT(A1,10))+TIMEVALUE(MID(A1,12,12))

You can perform arithmetic operations from the formula result i.e. Assuming start time is in Cell A2 and end time in cell B2, input into cell C2

=DATEVALUE(LEFT(B2,10))+TIMEVALUE(MID(B2,12,12))-DATEVALUE(LEFT(A2,10))+TIMEVALUE(MID(A2,12,12))

Upvotes: 1

Related Questions