D-Concentrate numbers
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
|