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