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.
