how to convert hh:mm:ss in to hour

[Nishajitheesh]

Hi,

Please help me to convert hh:mm:ss in to hour
sample file has been enclosed for your reference

Thanks & Regards,
Nisha

 

[pecoflyer]

Do you mean a decimal number?

 

[Peter Bartholomew]

An example of the required output would have been nice! @pecoflyer 's solution came as a surprise to be, not because of its content, but because it suggested an entirely different interpretation of the problem!