Extract time from a date time string in excel -

Extract time from a date time string in excel -

i have string in date , time format (10/25/2013 8:54:00 pm),i want extract time each cell , sum them find total time.

please can suggest me how it???

try formula extract time:

=time(hour(a1),minute(a1),second(a1))

then, summarize values , utilize "d h:mm" number format cell.

excel