Hi,

Am Thu, 21 Jul 2011 05:32:48 -0700 (PDT) schrieb rlm:

Converting 5:08:00 using =(HOUR(D2) *60)+MINUTE(D2) works perfect.
That turns out 308 minutes.

=D2*1440
and format General


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