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