We have a new manager at work and he wants us to timesheet. No problem, I have org-mode. Except, he wants time reported like this:

    0900-1000 Customer  Project  xMinutes
    0900-1000 Customer2 Project2 yMinutes
    1000-1100 Customer  Project3 zMinutes

So, in other words, if I clock time on three things in an hour he wants three lines for that hour which show the three sets of minutes that I spent, against the task. Naturally, my Org file has tasks for different customers as subheadings under those customers, so in theory those two columns should be easy.

I'm not very experienced with org hacking and I can't work out how to break the time down this way. So I thought I'd ask someone else to do it for me :)

Hopefully the answer isn't staring  me in the face in the Org manual.

   

    ** Greenwich Consultancy
       :LOGBOOK:
       CLOCK: [2016-02-18 Thu 10:40]--[2016-02-18 Thu 11:10] =>  0:30
       CLOCK: [2016-01-13 Wed 14:48]--[2016-01-13 Wed 15:29] =>  0:41
       CLOCK: [2016-01-12 Tue 11:00]--[2016-01-12 Tue 16:53] =>  5:53
       :END:
    ** PU [2/2]
    *** DONE Identify PU Open equella block
        CLOSED: [2015-10-26 Mon 09:09]
        :LOGBOOK:
        CLOCK: [2015-10-09 Fri 14:10]--[2015-10-09 Fri 16:06] =>  1:56
        :END:
    *** Update UAT 
        :LOGBOOK:
        CLOCK: [2016-02-17 Wed 10:03]--[2016-02-17 Wed 10:16] =>  0:13
        CLOCK: [2015-11-17 Tue 09:12]--[2015-11-17 Tue 09:18] =>  0:06
        CLOCK: [2015-11-16 Mon 14:49]--[2015-11-16 Mon 15:00] =>  0:11
        :END:
    *** PSMD Block
        :LOGBOOK:
        CLOCK: [2016-02-26 Fri 16:26]--[2016-02-26 Fri 16:53] =>  0:27
        CLOCK: [2016-02-11 Thu 14:27]--[2016-02-11 Thu 14:47] =>  0:20
        CLOCK: [2016-02-09 Tue 16:17]--[2016-02-09 Tue 16:31] =>  0:14
        CLOCK: [2016-02-09 Tue 14:24]--[2016-02-09 Tue 15:02] =>  0:38
        CLOCK: [2016-02-09 Tue 12:13]--[2016-02-09 Tue 13:01] =>  0:48
        CLOCK: [2016-02-09 Tue 10:15]--[2016-02-09 Tue 10:58] =>  0:43
        CLOCK: [2016-02-05 Fri 14:27]--[2016-02-05 Fri 16:36] =>  2:09
        CLOCK: [2016-02-05 Fri 11:11]--[2016-02-05 Fri 12:02] =>  0:51
        CLOCK: [2016-02-05 Fri 10:36]--[2016-02-05 Fri 10:53] =>  0:17
        CLOCK: [2016-02-03 Wed 09:39]--[2016-02-03 Wed 10:24] =>  0:45
        CLOCK: [2016-02-02 Tue 16:39]--[2016-02-02 Tue 17:00] =>  0:21
        CLOCK: [2016-01-29 Fri 12:27]--[2016-01-29 Fri 12:33] =>  0:06
        :END:       
    *** Server tidy
    **** STARTED Check TII code on UAT
         :LOGBOOK:
         CLOCK: [2016-02-25 Thu 16:59]--[2016-02-26 Fri 09:22] => 16:23
         :END:
    **** DONE Update Coursework M26 branch
         CLOSED: [2016-02-25 Thu 16:59]
         - State "DONE"       from "STARTED"    [2016-02-25 Thu 16:59]
         :LOGBOOK:
         CLOCK: [2016-02-25 Thu 16:56]--[2016-02-25 Thu 16:59] =>  0:03
         :END:   
    *** UAT PSMD Roamers problem
        :LOGBOOK:
        CLOCK: [2016-02-25 Thu 11:19]--[2016-02-25 Thu 11:33] =>  0:14
        :END:
    *** Gradebook problem
        :LOGBOOK:
        CLOCK: [2016-02-26 Fri 15:35]--[2016-02-26 Fri 16:26] =>  0:51
        :END:

So for example, the line 

    CLOCK: [2016-02-05 Fri 11:11]--[2016-02-05 Fri 12:02] =>  0:51

Should produce two output lines (with tabs or comma separators):

    1000-1100 PU PSMD Block 49
    1100-1200 PU PSMD Block  2