Change hours:minutes:seconds to days

Hello all,

I run a report the gives me time taken from start to finish as hhhh:mm:ss. This is almost always greater than 1 day and i would like to show it as days. Normally i would just reformat it as a number but that is not working with this data. ex: the data is stored as '22479:22:22' and reformating it to any data type won't change it. I would like to be able to add and subtract from this number and that is impossible right now. I believe getting that number to = 936.63 would solve my problems.

Is there a formula or something that i could apply to this?

thanks

=(left(a1,find(":",a1)-1)+(0&right(a1,6)))/24

Great thanks everyone! I actually found a different way to get what i needed without that data, but i apreciate all of the fast replies!