time sheets
I'm new to excel. I'm setting up a time sheet and would like to know what
calulation I use to figure out the hours worked with a 1/2 hour not being paid for. Thanks in advance. |
time sheets
Sam, have a look here for some functions
http://www.cpearson.com/excel/overtime.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Sam" wrote in message ... I'm new to excel. I'm setting up a time sheet and would like to know what calulation I use to figure out the hours worked with a 1/2 hour not being paid for. Thanks in advance. |
time sheets
Sam, if you are talking about =(F4-C4+(F4<C4))*24 if you put your mouse on the lower right hand corner of the cell it will turn into a small + drag down and it will fill the next row with =(F5-C5+(F5<C5))*24 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Sam" wrote in message ... Thank you that helped a lot. Is there a way to copy the formula into other rows? "Paul B" wrote: Sam, have a look here for some functions http://www.cpearson.com/excel/overtime.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Sam" wrote in message ... I'm new to excel. I'm setting up a time sheet and would like to know what calulation I use to figure out the hours worked with a 1/2 hour not being paid for. Thanks in advance. |
All times are GMT +1. The time now is 07:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com