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.