D-Concentrate numbers
in [General]
|
Prev: Charts Resize on Open
Next: line graphs
From: Kimti on 5 Apr 2010 15:06 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
From: "David Biddulph" groups [at] on 5 Apr 2010 15:27 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
From: Rick Rothstein on 5 Apr 2010 15:30 What kind of time is 05:87... 87 minutes after the hour? -- Rick (MVP - Excel) "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
From: Gary''s Student on 5 Apr 2010 16:00 In B1: =LEFT(A1,2) & ":" & MID(A1,3,2) -- Gary''s Student - gsnu201001 "Kimti" wrote: > 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
From: מיכאל (מיקי) אבידן on 5 Apr 2010 16:07
Try: =LEFT(A1,2)&":"&MID(A1,3,2) But..., the last tine I've checked - there were not more than 60 minutes in an hour. Micky "Kimti" wrote: > 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 |