• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hour kalendar magic Q?

Kyrre

Kyrre

Member
I have this csv-file that I convert to timesheet from me and employees.

Looks like this:
Fra csv til.jpg
Convert to this:
timeoveriskt.jpg
Now I can understand it, so my question is:

Can vi transpose it into a calendar? We have time, date and name of employee.
How can we do this?
Monday the 7. of a month, one line from 0800-1000 with project a, 1000-1200 with project b and so on.
 
Hi Hui
Yes I can do it later.
I am on mobile now. The resultant file for
This calendar I don't
have .

 
Project,Task,Details,Start,End,Duration,Decimal Duration
Renså,Fastpris,hente overliggende og skruer vindskiavslutning,2014-09-15 08:00,2014-09-15 11:09,3:09,3.15
Renså,Fastpris,"tid er ca,glemte starte",2014-09-15 11:59,2014-09-15 15:57,3:58,3.966666666666667
Renså,Fastpris,div ting å vise hvordan dem gjør det,2014-09-16 07:45,2014-09-16 09:56,2:11,2.183333333333333
kontorarbeid,matte,"regne jobb, se på jobb,regne faktura",2014-09-16 09:56,2014-09-16 15:57,6:01,6.016666666666667
Renså,Fastpris,"mønet, beslag pt",2014-09-17 08:36,2014-09-17 11:46,3:10,3.1666666666666665
Renså,Fastpris,Ferdig mønet og pipe,2014-09-17 12:00,2014-09-17 14:28,2:28,2.466666666666667
jupiterveien 16,Timearbeid,montere nedløp og vindskier,2014-09-18 08:03,2014-09-18 09:53,1:50,1.8333333333333333
jupiterveien 16,Timearbeid,"vindski, ferdig nedløp,heve gammel renne på nedsiden",2014-09-18 11:47,2014-09-18 14:00,2:13,2.216666666666667
Grovhageveien 5,Timearbeid,"ta av møne, lete feil",2014-09-18 14:00,2014-09-18 15:53,1:53,1.8833333333333333
Renså,Fastpris,"sjekke siste, spikre ferdig tak, hente retur",2014-09-19 07:45,2014-09-19 13:13,5:28,5.466666666666667
kalender.png
The calendar is just an example from web. I was thinking that different project name is shown in the correct appearance, like an time tracker list- wich it actally is.
Just to get a quick overview of where I have been last week or month.

Couldt att csv as a file, so I copied it and pasted it. The file is from app called Gleeo from android. That is the app we use for timetracking at our business.

Is this doable?

(It is not a point that we should export to an actually google calendar, but an excelsheet that look like an calendar)
 
You must log in or register to reply here.
Back
Top