Asked By
jutexleni
20 points
N/A
Posted on - 08/17/2011
I am using Microsoft XP and Office 2007. I have an Excel sheet. I input here entry time and exit time of all workers. I want to count all the workers' working hour. How can I count how many time the worker stays in the office?
Answered By
swathy
0 points
N/A
#115806
Count time from entry time and exit time
Hi,
-
Subtracting time in Excel is difficult. You cannot simply use numbers; sometimes it will result in negative numbers. So, all you can do is to use TIME function: next to the start and exit times.
-
=IF(A1>B1,B1+1-A1,B1-A1).
-
Here, “if” condition is used to avoid negative time errors.
-
A1 is the start time and B1 is the end time.
-
Copy & paste the function for all the users. Once the subtraction is done, you can use addition function to calculate the overall time for the particular day and for all the users.
-
You can use another method to see how many hours were calculated: Drag the mouse on “time calculated (using function said above)" tab until you reach the end; and you will find the sum of the numbers at the right end corner of the Excel page.
Hope this works perfectly!
Thank you.
Count time from entry time and exit time
Subtracting time in Excel is easy. You cannot simply use numbers. You will use time format.
-
A1 is the start time and B1 is the end time.
-
Then (= A1-B1).
-
You can use another method to see how many hours were calculated: Drag the mouse on “time calculated (using function said above)" tab until you reach the end; and you will find the sum of the numbers at the right end corner of the Excel page.
Hope this works perfectly!
Thank you.
