I'm gonna show you how to calculate the average of time the time is actually
written in English as opposed to scientific so here we have the
time that it takes the test subjects to complete a certain task and we have the
number of minutes and the number of seconds now there's a function called
time value that should work so you click on time value and click on this cell and
you close the bracket and the result is is a value error and that's because it's
looking for a date that you're doing it so it's trying to give you the time of
day that it's going to be so we're not going to do that what we're going to
certainly do first of all is I'm gonna separate the minutes from the seconds so
I'm going to go equals left and Open bracket going to select this cell and I
want the first two digits and so then I'm gonna press Enter
and now I'm going to click on this and double-click to get it to complete the
rest of them okay so now I'm going to try to get the seconds out of here
so I'm going to go equals mid and I'm gonna select this cell and it took me a
while to figure out what what the mid is I had to count literally so it's 16 and
the number of characters I want is two and so we're gonna close that and press
Enter and so we have 24 seconds and then we
double click to get there now there's a function called time so what I'm going
to do is I I'm going to go up and I'm gonna select
time and so we don't have any hours so I'm going to go immediately to the
minutes and I'm gonna select eleven and then I'm gonna go to the seconds and I'm
going to select the 24 and I'm gonna go okay now I don't want it in that format
I want it in the minutes and seconds so I'm gonna right click on this and I'm
gonna select format cells and I would like it to be minutes and seconds so I'm
going to select minutes and seconds here okay so now to finish this I'm going to
double click on our fill handle to bring it down and so here we have our 11 hours
and 24 it's 11 minutes and 24 seconds so to create an average it's very very easy
you go to the cell below it you go next to your automatic sum function and you
select average and it's suggested the right numbers and then we say that
sounds fine and you see the average time to complete this task was 33 minutes and
14 seconds and so just to be scientific what I'm going to do is I'm going to put
a graph in here so we'll go insert and we will go recommended charts and it
doesn't really like to recommend anything so I'm going to go with this
one and say ok so I'm going to change the chart time to time spent
and there you go the problem is salt so that's how you calculate the average
when the time is written in English please subscribe