Thanks cris, you helped me solve my issue

and I will definately follow forum's rules next time 😉

Thanks alot 🙂

I have a feild in a table of type varchar that contains time as

hhh:mm:ss

e.g 73:59:59 or 144:44:59

What I want is to get time in hours, can anyone help me write...

Thanks ryan.mcatee brother, it solved my problem

thanks for quick response