Solved: Time&Date Calculation and Formatting issue

[daemonskin1]

Hi Forum,

Time/Date formatting issue I have is:

john.doe.80010112004 (where the number represent hmmMMDDYYYY)

mary.jane.81310112004 (where the number represent hmmMMDDYYYY)

-----------------------------------------------------------------

Desired output (with least formatting steps performed)

0:13 ((hh:mm) (as the total time elapsed))

Thanks in advance for the suggestions!

[Bob Phillips]

Hi Forum,

Time/Date formatting issue I have is:

john.doe.80010112004 (where the number represent hmmMMDDYYYY)

mary.jane.81310112004 (where the number represent hmmMMDDYYYY)

-----------------------------------------------------------------

Desired output (with least formatting steps performed)

0:13 ((hh:mm) (as the total time elapsed))

Thanks in advance for the suggestions!

=--RIGHT(LEFT(A51,LEN(A51)-8),2)/24/60/60

and format as time

[daemonskin1]

Thanks a lot XLD!