Hi,
we want to use Tempo for Time Tracking which will be used for each employee as a covenant time table for our payroll accounting.
We are bond to keep tracks of time like
08:00-10:30 Installed tempo Plugin
10:30-12:00 Tested Configuration.
At least it should state something like
08:00-12:00 worked
13:00-18:00 worked
But it is possible for me to enter something like this:
08:00 worked 8h
13:00 worked 5h
Hi Claus
A similar request is in our tracker https://studio.plugins.atlassian.com/browse/JTMPO-511
I ve commented a link to this post in the issue so please feel free to vote/comment on the issue.
Sverrir Tynes
Tempo support
Maybe a helpfull SQL for MySQL-DB
select w.AUTHOR, i.pkey, w.STARTDATE, ADDDATE(w.STARTDATE, INTERVAL w.timeworked/60 MINUTE) as ENDDATE , w.timeworked/60 as WORKED_IN_MIN, w.worklogbody , case when w.startdate = ww.startdate and w.timeworked= ww.timeworked and w.worklogbody = ww.worklogbody then 'duplicate entry' when w.startdate = ww.startdate and w.timeworked= ww.timeworked then 'duplicate time entry' when ww.startdate = w.startdate then 'duplicate STARTDATE' when ww.startdate > w.startdate and ww.startdate < w.startdate then 'second time completely included' else 'overlap' end as INFO , ii.pkey, ww.STARTDATE, ADDDATE(ww.STARTDATE, INTERVAL ww.timeworked/60 MINUTE) as ENDDATE , ww.timeworked/60 as WORKED_IN_MIN, ww.worklogbody from worklog w inner join jiraissue i on i.id = w.issueid inner join worklog ww on w.id <> ww.id and w.AUTHOR = ww.AUTHOR and ww.STARTDATE >= w.STARTDATE and ww.STARTDATE < ADDDATE(w.STARTDATE, INTERVAL w.timeworked/60 MINUTE) inner join jiraissue ii on ii.id = ww.issueid order by w.AUTHOR, w.STARTDATE, i.pkey, ww.STARTDATE
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.