Count time from entry time and exit time

Asked By 20 points N/A Posted on -
qa-featured

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
Best Answer by swathy
Best Answer
Best Answer
Answered By 0 points N/A #115806

Count time from entry time and exit time

qa-featured

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

qa-featured

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.

Login/Register to Answer

Related Questions