Automated substraction of time

**ljuboja** · 02-01-2011, 01:35 PM

This my problem:I got exel sheet which is populated from .txt file a list of song names,artists, start time of song.My problem is how to get duration of each song in separate column labeled duration by substraction B5-B4, B6-B5 and so on, but in somehow in automated sense, because i got several thousend song.
Example sheet:
A B C D
Start Artist Song Title Duration

0:50:37 REM Pop Song ?
0:53:50 Gang of Four Man in Uniform ?

Thanks

**NBVC** · 02-01-2011, 01:44 PM

If you enter:

=B5-B4

then you can easily copy that down the column by click and dragging the little black box at the bottom right corner of the cell that you enter the formula in... the cells will automatically increase as you copy down.

**ljuboja** · 02-01-2011, 01:49 PM

thanks a lot, Best regards

**ljuboja** · 04-13-2011, 06:31 AM

This works well, but problem is when i reach to "end of a day":
A B C D
Start Artist Song Title Duration

23:58:37 REM Pop Song ?
00:03:50 Gang of Four Man in Uniform ?

Then result in column is ##########

How to fix this?