Difference between two times using MS Excel

KIndly let me as to how to calculate the difference between two times say 10.30 am & 1.45 pm using formula in MS Excel.

Replies (4)

Before using any formula format the two cells in time format.And just subtract 2nd cell from 1st .

like

=A2-A3

Thanks for your reply.Actually I haven't been able to format the cells in time format.Please explain step wise to do the same

Dear

you can format the cell in time format or if you want you can do this without formation.

 

just write. 

in cell A1 and in cell A2 (assuming clock of 24hours)

14:40 (means its 2:40 pm)

2:30 (means its 2:30 am)

now write

=A2-A1 or vice versa.

 

:) hope now this is clear.

Select the cells and press CTRl+1 (not from numeric keypad) and u will be prompted to select format cells

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
19 October 2026
Accountants/Articles (Freshers/Experienced)

ADY & CO.

New Delhi

Graduate (Any)

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details