Design is attached,
I will click on "Enter Time" button to enter the current time in desired active cell, similarly whenever the task complete I will enter the End time.
But the requirement goes below:
1. Need to calculate the time difference, by clicking in "Time Diff" button, should calculated to the whole sheet ( C and D columns)
If start time is there and End time is not present
the difference of that respective cell should be blank not "#value" kind of error.
2. In summary sheet, If E2=1, then it should calculate the Day1 sheet, howmany are "pending" & "Completed" from the Column F of Day1 sheet.
Similarly If E2=2 means, it should calculate from Day2 sheet.