| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the formulae to write a work timecard in Excel
I am a payroll student and want to write a work timeclock ( clocking in and
out card) what is the formulae I need i.e In 06:30 Out 12:00 In 13:00 Out 17:00 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What is the formulae to write a work timecard in Excel
Payroll student ? B2: 06:30 C2:12:00 D2: 13:00 E2: 17:00 F2: =c2-b2+(b2c2)+e2-d2+(d2e2) The use of D2E2 is a comparison it will add 24 hours (1 day) if the ending time is less than the starting time. So if a shift began on one day and ended on the next day, your formulas would work. More information on Date and Time in http://www.mvps.org/dmcritchie/excel/datetime.htm http://www.cpearson.com/excel/datetime.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Billious0" wrote in message ... I am a payroll student and want to write a work timeclock ( clocking in and out card) what is the formulae I need i.e In 06:30 Out 12:00 In 13:00 Out 17:00 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What is the formulae to write a work timecard in Excel
Many thanks for you very helpful reply. I am doing a Distance Learning Course
in Payroll, and needed to setup a Excel worksheet fot a timeclock to workout how many paid hours an employee had worked, and then work out from a given hourly rate the employees wage plus bonus. Again thank you. you. "David McRitchie" wrote: Payroll student ? B2: 06:30 C2:12:00 D2: 13:00 E2: 17:00 F2: =c2-b2+(b2c2)+e2-d2+(d2e2) The use of D2E2 is a comparison it will add 24 hours (1 day) if the ending time is less than the starting time. So if a shift began on one day and ended on the next day, your formulas would work. More information on Date and Time in http://www.mvps.org/dmcritchie/excel/datetime.htm http://www.cpearson.com/excel/datetime.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Billious0" wrote in message ... I am a payroll student and want to write a work timeclock ( clocking in and out card) what is the formulae I need i.e In 06:30 Out 12:00 In 13:00 Out 17:00 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What is the formulae to write a work timecard in Excel
See www.cpearson.com/excel/overtime.htm for a sample timecard.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Billious0" wrote in message ... I am a payroll student and want to write a work timeclock ( clocking in and out card) what is the formulae I need i.e In 06:30 Out 12:00 In 13:00 Out 17:00 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What is the formulae to write a work timecard in Excel
This is most helpful, as I do have to work out varible overtime rates.
Many sincere thanks. "Chip Pearson" wrote: See www.cpearson.com/excel/overtime.htm for a sample timecard. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Billious0" wrote in message ... I am a payroll student and want to write a work timeclock ( clocking in and out card) what is the formulae I need i.e In 06:30 Out 12:00 In 13:00 Out 17:00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to write a formulae | Excel Worksheet Functions | |||
| who can write Excel Formulae | Excel Worksheet Functions | |||
| How do you subtract time as in a timecard to calculate hours work | Excel Worksheet Functions | |||
| Formulae to work out break even point? | Excel Worksheet Functions | |||
| when copying formulae from one cell to another it does not work | Excel Worksheet Functions | |||
Linear Mode
