Prev: Charts Resize on Open
Next: line graphs
From: Kimti on 5 Apr 2010 18:27
Thank you David, it worked OK.

"David Biddulph" wrote:

> You might need to explain what sort of time 05:87 is. For most of us, there
> are only 60 minutes in an hour, and only 60 seconds in a minute. If you
> have text such as 0527-1856 in column A, and you want to get a time of
> 05:27, try =--TEXT(LEFT(A1,4),"00\:00") and format as time to suit.
> --
> David Biddulph
>
>
> "Kimti" <Kimti(a)discussions.microsoft.com> wrote in message
> news:6BDB9C41-C30C-46A5-BB51-6F2AA21D2CE9(a)microsoft.com...
> > I am trying to delete some numbers from a column for example:
> >
> > column A has total duration of a task times 0587-1856 and I would like to
> > have column B with only first four numbers 05:87 (start time for the
> > task).
> >
> > Please help on this formula.
> >
> > Thanks in advance for your help.
> >
> > Kimti
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Charts Resize on Open
Next: line graphs