[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel related question, delete if not interested


  • To: omega list <omega-list@xxxxxxxxxx>
  • Subject: Re: Excel related question, delete if not interested
  • From: Massimo Ciarafoni <maxci@xxxxxx>
  • Date: Mon, 28 Sep 1998 06:53:37 -0400 (EDT)

PureBytes Links

Trading Reference Links

Allan

Thank you for the valuable advice, I took your formula and modified
slightly
to produce the wanted result.
The formula I used is =Time(Trunc(C2/100,0),Mod(C2,100),0).
That produced the time format TS likes, I also found out TS gets
confused if
AM/PM are used in the ascii source file when the time change from 12:59
PM
(12:59 not 23:59) to 1:00PM (13:00).

Thanks again.

Allan Kaminsky wrote:

> At 05:54 PM 9/27/98 +0200, Massimo Ciarafoni wrote:
> >Does anyone know the Excel formula to modify the following format
> >930,....1715, into 9:30 AM,.....5:15 PM ?
> >I'm trying to plot a tick-by-tick ascii file with the following
format
> >for the time 1031 but it seems TS can't read it if the time format is

> >not hh:mm AM/PM.
> >Thanks in advance.

> Create a new column (say B, for example's sake, assuming the time
entries
> are in A).
> At B1 (or whatever), enter the following formula:
>
> =TEXT(TIME(A1/100,MOD(A1,100),0),"h:mm AM/PM")
>
> where A1 is the cell containing the first time value to be modified.
>
> Copy it down for the extent of the time entries.
>
> If you wanted, you could then create yet another column and copy
column B
> 'by value', thus eliminating the dependence on the original time
values.
> Allan