Sam,
Thank you for that, it saves a column.
John
On Wed, Nov 2, 2011 at 9:25 PM, Sam Mathai Chacko wrote:
> 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:
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 wrote:
> Hello John,
>
> If the Arrival Date & Time is "09/08/2011 2310" & Length is 343 (Row 3
> data) Finish date & time is 09/09/2011 04:53. Arr
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 wrote:
> Hello John,
>
> If
Ashish,
Wonderful. Works just as I need. Thank you for your continued help.
John
On Wed, Nov 2, 2011 at 9:02 AM, ashish koul wrote:
> see if it helps
>
>
>
>
> On Wed, Nov 2, 2011 at 4:38 PM, John A. Smith wrote:
>
>> I receive a download which shows Arrival Time as “09/14/2011 0938” and I
>
