Difference between two times using MS Excel

Pranjal (Student CA IPC / IPCC) (531 Points)

06 December 2010

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.

Reply
Follow
Share

4 Replies

CA GIRISH (Chartered Accountant) (1796 Points)
Replied 07 December 2010

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

=A2-A3

Pranjal (Student CA IPC / IPCC) (531 Points)
Replied 07 December 2010

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

vkbothra (Learning ) (690 Points)
Replied 18 December 2010

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.

CA GIRISH (Chartered Accountant) (1796 Points)
Replied 20 December 2010

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

Start a New Discussion

view all classess

Forum Home