Hours Calculation

[hari8088]

Hi All,

I have data like Employee name,Start time,End time and use are the Columns.

Here my output like

Output Format:

This is example only not exact output

              Mailchecking    Meeting   Reportpreparing

Hour1        15.00              45.00          0.00

Hour2      

Hour3

Hour4

Hour5

Hour6

Hour7

Hour8

Hour9

Want to calculate employee timings(how much time they spend)  hour by hour by using their start time(here employee start time is different for each one).

For example:

Employee A his start time is 8:30 AM

Then he spent 15 min for mail checking and then next one hour he spend time for report sending.(8:45 to 9:45)

From 9:45 to 10:45 he spent time for meeting.

My output like:

                  Mailchecking   Reportsending     Meeting

Hour1            15.0                 45.00                0

Hour2           0                        15.00             45

Because Hour1 will be between 8:30 to 9:30

Means every hour we have to differentiate and have to show their use in above format.

Here am attaching sample data

Thanks in advance.

[el_aprendiz111]

good afternoon

attached qvw if it serves you.

[ziadm]

Attached is how to do it

[ziadm]

Table1:

LOAD Date as WorkinDate,

    Empname,

    Monitaring,

    Startrime,

    Endtime,

    Interval(Endtime -Startrime ,'mm') as TimeTaken,

    Use

FROM

(ooxml, embedded labels, table is Sheet1);

Create a Chart Table where your Dimensions are

WorkingDate

Empname

Use

and your Measure will be Sum(TimeTaken)

[hari8088]

Hi Fer,

Good evening,Thanks for your replay.

This is not what am looking for this scenario.

My dimension will be hour that will contain

Hour

.......

Hour1

Hour2

Hour3

.

.

.

.

.Hour9

This is the field that need to bring then the usage off all employees between one hour should come under Hour1 like this.

[hari8088]

Hi Ziad,

Good evening,Thanks for your replay.

This is not what am looking for this scenario.

My dimension will be hour that will contain

Hour

.......

Hour1

Hour2

Hour3

.

.

.

.

.Hour9

This is the field that need to bring then the usage off all employees between one hour should come under Hour1 like this.

[el_aprendiz111]

Hi Hari

[tajmohamed30]

Have you checked interval match function

[ahaahaaha]

Hi,

May be like in attached file

Andrey

[hari8088]

Hi Fer,

This is the output i required.

Thanks,