convert time
Hi Kevin,
Am Thu, 31 May 2012 05:21:37 -0700 (PDT) schrieb kevcar40:
i have a field on a worksheet formatted as [h]:mm:ss
i would like to convert this to decimal time
i.e
29:26:24 = 29.43
your time in A1, then in B1:
=A1*24 and B1 formatted as General
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|