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

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" wrote in message
...
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

What kind of time is 05:87... 87 minutes after the hour?

--
Rick (MVP - Excel)



"Kimti" wrote in message
...
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

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

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

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" wrote in message
...
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


.