convert time

[kevcar40]

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

 

[Claus Busch]

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

 

[kevcar40]

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