I am doing my Msc Ecology thesis and in the process of organizing my data set. When inputting my data for the amount of time a skink spent in a hole I inputted `h:mm:ss`

for the time it went in and the time it came out.

I then subtracted the 'out' time from the 'in' time to find the amount of time it spent in the hole. I formatted this cell as `[ss]`

. I am now trying to find the average time the skink spend in a hole. I am having problems because I can only get the average number of seconds, using `=average()`

, when I use only numbers in `[ss]`

format.

Some of my other numbers are in general format (due to how I collected data). When I ask for say the average of 16.1 sec in general format and 86 sec in `[ss]`

format the answer is 8.1. Thus I would like to change the formatting of the `[ss]`

formatted data to general or number format. I have tried this and instead of keeping the number of seconds, it changes it to a much smaller number e.g. 86 seconds becomes 0.00099537.