Hi Ditchy,

Am Sat, 9 Jul 2011 00:39:57 -0700 (PDT) schrieb Ditchy:

how can I convert 00:06 minutes to 6
tried the =RIGHT(AA8,LEN(AA8)-4)*1
but can't seem to get it to work?
could some one please point me in the right direction.

your time in A1. Then:
=A1*1440 and format "General"


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2