Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to add time duration of song tracks together with information
that was copied and pasted into excel from iTunes. The song length is in format 04:33 meaning 4 mins and 33 seconds. In trying to sum several song lengths together it becomes clear that excel is reading this 04:33 as 4 hours and 33 minutes which gives very peculiar results if you are looking for total running times for various groups of songs. How do I get excel to recognise this copied data as minutes and seconds rather than hours and minutes. In trying to format the cells to minutes and seconds it changes the values, I do not want this. Please Help! Thanks in Anticipation -- Ravi B |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
External Data Source from Excel Workbook with names | New Users to Excel | |||
Update External Data source from Excel sheet | Excel Discussion (Misc queries) | |||
Delete the formulas of webpage, copied & pasted on excel sheet | Excel Discussion (Misc queries) | |||
Prevent Hidden Column data from being copied/pasted? | Excel Discussion (Misc queries) | |||
Formatting information copied and pasted from the WEB to excel | Excel Discussion (Misc queries) |