It is showing the time in minutes, you need to divide by 86400 and format
TEXT(playtime/86400,"mm:ss")

Signature
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
> Recently to avoid cd buying duplication i started to create a excel
> database of my audio cd collection , artist, track,cd name, duration of each
[quoted text clipped - 22 lines]
> ------->>>>>>http://www.NewsDemon.com<<<<<<------
> Unlimited Access, Anonymous Accounts, Uncensored Broadband Access
Ron Rosenfeld - 30 Oct 2006 12:27 GMT
>It is showing the time in minutes, you need to divide by 86400 and format
^^^^^^^
seconds
>TEXT(playtime/86400,"mm:ss")
--ron
geewhizza - 30 Oct 2006 17:26 GMT
Thanks for the replies...much appreciated!.