answersLogoWhite

0

There are 2 ways to do this depending on HOW your clock card (time card) records the start and finsh times.

as its complex in related link is the both options for you in simple terms

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What to do when you need Excel lines on paper printout?

don't really remember its been a long time since ive used Microsoft excel try clicking file > setup.. sorry i cant be of more help


What is the name of the Excel feature that recalculates formulas every time you enter a value into a cell?

auto-calculate


A calculation used in excell?

Calculate means Excel will evaluate formulas and functions to display the result. You can turn calculate to manual or auto. When it is on auto, everything is updated in real time. Manual will update when you open Excel or requires to you click the calculate button every time you want to see results.


What is the Excel credit card payoff formula for calculating the amount needed to pay off a credit card debt?

The Excel credit card payoff formula is PMT(rate, nper, -balance). This formula calculates the monthly payment needed to pay off a credit card debt within a specific time frame.


Are there any internet Date Time calculators that can calculate the exact middle date and time between two dates?

You can easily do this with Microsoft Excel or OpenOffice's spreadsheet module.


How can we use the ABS function in Excel?

ABS returns the absolute value, so you use it any time you want to view or calculate with the absolute value.


How do you calculate how much you will pay in interest on a loan or credit card?

To calculate the interest on a loan or credit card, you multiply the interest rate by the amount borrowed and the length of time the money is borrowed for. This will give you the total amount of interest you will pay over the loan or credit card term.


What is meant by setup time?

The setup time is the time that the data inputs must be valid before the clock transition.


How many different format choices are there for time in Excel?

In MS Excel 2010, there are 8 ways to format Time Cells


Which backup site would require NO setup time at the occurrence of an emergency Which backup site would require NO setup time at the occurrence of an emergency Which backup site would require NO setup?

Mirrored


How do you time stamp a cell in Microsoft Excel?

You do not. Excel does not record the change date of an individual cell.


How to make attendance in Excel: A Step-by-Step Guide for Workstatus Users?

Are you looking for a way to track employee attendance in Excel? Look no further! In this article, we'll show you how to create a simple attendance tracking template in Excel, using the features of Workstatus. With this template, you'll be able to easily track employee hours, calculate attendance, and generate reports. Follow these steps to get started: Open a new Excel spreadsheet and create a table with the following columns: Employee Name, Date, In Time, Out Time, and Total Hours. Enter the employee names in the first column, and the dates in the second column. Use the "In Time" and "Out Time" columns to track the start and end times of each employee's shift. Use the "Total Hours" column to calculate the total hours worked by each employee. Use formulas to calculate the total hours worked by each employee, and to generate reports. By following these steps, you'll be able to create a simple attendance tracking template in Excel that will help you track employee attendance and generate reports.