Haseeb,
Thank you for that. That solved an unrelated issue and was very helpful,
thank you.
John
On Wed, Nov 2, 2011 at 8:22 PM, Haseeb Avarakkan haseeb.avarak...@gmail.com
wrote:
Hello John,
If the Arrival Date Time is 09/08/2011 2310 Length is 343 (Row 3
data) Finish date time is
Sam,
Thank you for that, it saves a column.
John
On Wed, Nov 2, 2011 at 9:25 PM, Sam Mathai Chacko samde...@gmail.comwrote:
If you only want the finish time without splitting it in to Date and Time,
you could also use
=LEFT(TRIM(A23),10)+TEXT(RIGHT(TRIM(A23),4),00\:00)+(B23/(60*24)) in
If you only want the finish time without splitting it in to Date and Time,
you could also use
=LEFT(TRIM(A23),10)+TEXT(RIGHT(TRIM(A23),4),00\:00)+(B23/(60*24)) in
mm/dd/ hh:mm format
Regards,
Sam Mathai Chacko
On Thu, Nov 3, 2011 at 5:52 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com