Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lorenzo Lee   on Sep 10 In MS Office Category.

  
Question Answered By: Pam Harrison   on Sep 10

I didn't read the earlier posts on this thread, but assuming the sample data
given is in A1:B3 try this:

In C2: =TIMEVALUE(LEFT(A2,LEN(A2)-4)&":"&MID(A2,LEN(A2)-4,2)&":"&RIGHT(A2,2))
In D2: =TIMEVALUE(LEFT(B2,LEN(B2)-4)&":"&MID(B2,LEN(B2)-4,2)&":"&RIGHT(B2,2))
In E2: =D2-C2

Total difference  in minutes (in F2): =(HOUR(E2)*60)+MINUTE(E2)
Seconds portion of difference (in G2): =SECOND(E2)

Copy formulas down as needed. Hope this helps,

Share: 

 

This Question has 9 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Finding difference in time Or get search suggestion and latest updates.


Tagged: