answersLogoWhite

0


Best Answer

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

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you setup excel to calculate time for a time card?
Write your answer...
Submit
Still have questions?
magnify glass
imp
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.


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.


What is meant by setup time?

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


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.


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 many different format choices are there for time in Excel?

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


What are the cost drivers which are used in apportioning overheads cost under activity based budgeting?

Cost drivers are activities due to which cost incurred for expample as many time as machines are setup for production as many time machine setup cost will be incurred so matchine setup is cost driver.


WHAT account setup if you do not have time to finish an account setup task what can you do to save your work?

Click the File for Later button


How to install Office 365 ?

Microsoft offers a full list of tools that make not only you but also your colleague more productive.You can use the office suite features to collaborate with your colleague even remotely. For example, you can use Word, Excel, and PowerPoint collaborating online and can see the changes as happening co-authoring in MS Word in real-time. Sign in, enter the Office setup key, and download Office from office setup. After installation, check the subscription at office setup.


How do you time stamp a cell in Microsoft Excel?

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