►
From YouTube: How to track Time on Task using Google Sheets
Description
If you want to copy this sheet into your sheet, click here -- https://docs.google.com/spreadsheets/d/1rvhUcNlSzs6STv3EGWDddohxOo3F99ZRHN9W7wjBzIo/copy
A
Hello,
if
you
are
trying
to
do
a
moderated
usability
test
or
something
where
a
user
has
a
set
of
tasks
and
you're,
trying
to
track
time
on
task
and
you're
having
like
a
hard
time
manually,
tracking
it
with
a
stopwatch
or
some
sort
of
web
app
or
something
like
that.
A
This
is
a
way
of
automatic
kind
of
automatically
tracking
time
on
task.
With
a
couple
check
boxes
into
any
sort
of
Google
sheet.
You
don't
have
to
use
this
template
I'm,
going
to
explain
how
to
put
it
in
another
template,
but
you
can
copy
this
and
and
work
with
it.
If
you
want
on
your
own
and
I
will
explain
what
this,
what
this
template
is,
so
just
to
start
to
see
how
the
how
to
use
this
sort
of
thing.
A
So
if
a
user
has
started
the
task
that
they
need
to
start
that
you
identified,
then
you
would
click
or
hit
spacebar
on
the
task
begin
column
and
then,
whenever
it
is
that
they
have
finished
like
whatever
your
set
end
is,
then
you
can
you'd
click
on
the
task
in
column
and
then,
when
you
click
on
each
of
those
columns,
a
timestamp
is
put
in
at
that
point
into
a
different
column,
and
then
there
is
a
separate
column
with
an
equation
that
calculates.
What
that
difference
in
time
is
in
seconds.
A
If
you
want
but
yeah
and
then,
if
you
say
you
wanted
to
you
know
you
accidentally
hit
one
of
the
buttons
or
or
whatever,
then
you
could
hit
the
reset
and
it
resets
the
whole
thing,
and
so
what
you
would
do
is
you
would
say,
like
task,
one
or
whoops
test
it,
whatever
task
three
so
on
and
so
forth,
and
then
you
know,
as
that
person
does
that
task
you
go
and
then
you
click
each
one.
A
And
then
you
continue
down
the
line
and
then
what
you
can
do
is
you
can
hide
these
columns
if
you
want
to
make
it
easier-
and
you
can
just
get
this
also
if
for
whatever
reason
like,
if
you
want
to
you,
know
copy
and
paste
that
data
you
can
copy
and
you
can
make
sure
to
paste
and
paste
values
only
and
then
that'll
give
you
this.
You
can
change
that.
You
know
you
could
do
whatever
you
want
with
that.
A
If
you
want
to
like
create
averages
that
whole
sort
of
thing,
but
that's
a
just
an
easy
way
to
copy
that
data,
and
if
you
wanted
to
copy
this
whole
sheet
for
each
participant
or
for
each
session,
then
this
script.
The
way
that
this
script
is
set
up
is
to
identify
anything
that
has
session
in
the
title.
Just
because
that's
what
I
happen
to
call
my
sessions,
so
you
just
create
another
one.
A
As
long
as
it
has
the
name
session
in
it
spelled
obviously
the
correct
way
with
the
correct
the
same
capitalization
and
the
same,
it
will
work
in
the
same
way.
Oh
I.
Have
it
actually
set
up,
so
it's
because
I
that
was
from
an
old
version.
So
if
you
wanted
to
do
this,
you
just
copy
that
sheet
and
then
it'll
work
the
same
and
then
say
you
do
something
you
say
oops.
They
did
not
actually
just
end
it.
A
What
you
can
do
is
delete
that
column
really
quickly
and
then
hit
that
again
recheck
that
and
it
will
re-trigger
it.
I
can
also
make
a
a
version
of
this
script
that
will
do
it
for
each
like
check
and
uncheck.
It
will
so
say
like
if
you
check
it,
it
leaves
the
time
stamp
and
then,
if
you
uncheck
it
theoretically,
it
should
delete
the
timestamp.
A
I
may
do
that
and
if
I
do
it'll
be
after
this,
video,
so
I
will
just
go
ahead
and
create
basically
in
the
script
which
I
can
go
ahead
and
show
you
now
I
will
put
an
additional
function
in
the
script
and
then
comment
that
function
accordingly.
So
it's
super
clear,
but
now
to
show
the
actual
script.
This
is
here.
A
If
you
want
to
edit
it
or
copy
it
or
put
it
in
another
sheet,
like
one
of
your
own
sheets,
you
can
go
and
click
extensions
and
then
apps
script,
and
then
this
is
where
the
actual
JavaScript
lives,
but
I
also
included
it
here.
Just
in
case
you
didn't
want
to
go
ahead
and
do
all
of
that.
You
can
just
go
through
all
this
copy
and
paste.
A
It
won't
paste
the
the.
What
do
you
call
them
cells
or
anything
like
that,
but
anyways,
so
just
to
give
you
an
overview
of
how
it
works.
There's
three
things
that
actually
matter
and
I
will
go
ahead
and
separate
these
things.
These
are
right
here.
I
commented
out,
as
you
can
touch
these
variables
with
a
little
smiley
face.
The
variables
are
the
sheet
name,
the
start
row
and
the
task
begin
column
I.
Will
the
sheet
name?
A
I
explained
earlier,
it's
just
whatever
the
sheet
is
named
and
then
to
actually
explain
the
other
two
I'll
go
to
here,
because
I
put
a
little
comment
on
here.
We
go
a
little
comment
on
where
these
actually
are
in
the
sheets,
so
the
task
begin
column,
which
is
what
it
is
right.
There
refers
to
the
First
Column
that
you
want
the
function
to
actually
look
at
basically,
so
the
function
needs
a
range
to
operate
in,
and
this
is
the
range
that
the
function
operates
in
this
whole,
it
just
keeps
going
down.
A
Basically,
so
you
give
it
the
the
first
column
in
that
range
and
then
the
row
in
that
range
and
then
I
have
it
automatically
set
up
to
have
each
of
these
columns
in
this
order,
so
it
will
automatically
assign
those.
If
you
want
to
change
them,
then
you
can.
You
would
just
go
here
and
then
like
set
this
to
you
know
three
or
whatever
you
wanted
to
do
if
you
wanted
on
the
third
column,
otherwise
you
can
just
leave
it
as
is
but
yeah,
that's.
Those
are
the
only
things
you
would
really
need.
A
So,
if
you
wanted
to
say
put
this
in,
like
you
know
a
separate
area
in
your
sheet
like
if
you
had
a
whole
bunch
of
instructions,
different
formatting
and
stuff,
like
that,
you
had
all
the
things
up
here
and
stuff
like
that.
You
can,
and
you
just
have
to
designate
then
this
section.
Basically,
as
a
section,
you
want
the
function
to
actually
operate
in
but
yeah
there
you
go.