Time sheet Calclulation from raw data

Dear all,

Please find excel attachment.
I have sample data in “DATA” tabs.
I would like to display them like on “OUTPUT” tab using macro or pivot or formula with calculation on “Worked Hours” column.

Please help me to generate report.

Regards

Vinay

See if the attached Pivot Table is what you want.
You need to change your worksheet structure to have a separate column for Time In and Time Out, then another column to calculate the hours worked.