 ## Count time from entry time and exit time

Asked By 20 points N/A Posted on -

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? SHARE Answered By 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. Answered By 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. 