Hi people, I need help with Excell formula!
in F column I have duration of songs in mm:ss (ex. 03:30) and in A I have to count it in format hh:mm.
So for example, if songs stars exactly in midnight 00:00 and duration of it is 03:30 in A1 must be 00:03.
The tabel must look like:
00:00 (midnight) Kylie Minogue - All The Lovers 03:00
00:03 Take That - The Flood 04:00
00:07 ... etc. (I need this for 24h)
thanks a lot!
Bookmarks