PDA

View Full Version : Solved: Time&Date Calculation and Formatting issue



daemonskin1
11-08-2005, 12:32 AM
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! :help

xld
11-08-2005, 02:07 AM
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! :help


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

and format as time

daemonskin1
11-08-2005, 02:52 AM
Thanks a lot XLD! :beerchug: