Count time from entry time and exit time

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?

• Status: Open
• Question Views: 1025
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by swathy

Go To Solution

Best Answer

Best Answer

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.

About swathy

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/17/2011
• Question Category: MS Excel

Answered By monowar4701 0 points N/A #115808

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.

About monowar4701

Questions
0

Answers
10

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/18/2011
• Question Category: MS Excel