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