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
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.