| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting excel to recognise copied data as mm:ss not hh:mm
I have copied track information from iTunes into Excel but it is reading the
track length as hours and minutes when it is in format 04:32. How do I get it to read this as minutes and seconds so that I can organise lists and do sums on total running time. Thanks -- Ravi B |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Having to Press F2 to recognise data from another sheet in Excel | Excel Discussion (Misc queries) | |||
| After concatenating data, how do I get Excel to recognise date? | Excel Discussion (Misc queries) | |||
| Excel automatically copied data from one cell to another... | Excel Discussion (Misc queries) | |||
| converting copied data to numbers in excel xp | New Users to Excel | |||
| can i convert data copied as an image into data in excel ? | Excel Worksheet Functions | |||
Threaded Mode
