convert time
 

hi
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
can anyone please tel me the formula

thanks

kevin

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

convert time
 

On Thursday, May 31, 2012 1:21:37 PM UTC+1, kevcar40 wrote:
hi
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
can anyone please tel me the formula

thanks

kevin

thanks

some time the obvious is missed