| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
D-Concentrate numbers
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 . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| concentrate muli cells | Excel Worksheet Functions | |||
| =&'', "& or concentrate formula | Excel Worksheet Functions | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Threaded Mode
