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
But it is possible for me to enter something like this:
08:00 worked 8h
13:00 worked 5h
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.
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
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs