Is there any way to have time constant in an Org spreadsheet formula? For example, i would like to have something like this:
@>$3=@>$5-'08:00:00'*vcount(@2..@-1)
to calculate how much longer I've been at work than I have to be :) The @>$5
is the total sum of hours I've been at work and @2..@-1
are the rows with days I've been working.
org-clock-in
.