Excel Date and Time issue

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello All,

I wanna subtract "12/05/10 08:29:25" from "12/05/10 08:48:31' . Please help me out.

Thanks and Regards,
Subramanyam T C,
Bangalore.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
enter 12/05/10 08:48:31 in A1
enter the other time in A2
in an empty cell e.g. A3 enter the formula
=A1-A2

format A3 as Time something like
13:30:55 (depending upon your version of excel)

the result will be
0:19:06
that is 19 minutes and 6 seconds.