|
time sheet
Hi all My payroll officer has pointed out to me that the time sheet i have created is good but i am loosing out on cash because the way they work out the hours is different to the way my time sheet dose, on my time sheet if i work for 7 H and 40 Mins it Displays as 7:40. But here is where i lose out as when the payroll see 7:40 they take it as 7H 24Mins. Dose anyone have a suggestion as to how i can get 7:40 to display the correct time (7:67) with out starting from scratch? the payroll work on the following setup 1min= .02 10mins= .17 15mins= .25 20mins= .33 30mins= .50 40mins= .67 etc. these are my current formulas cacluates lunch period =E10-D10 total time worked less total lunch =((F10-C10)-G10) total OT for the day =J10-I10 Total Time Worked + OT =SUM(H10:H23)+K24 (K24 is the cell containing the total of the over time) this time sheet covers a F/N Thanks in advance Regards, Jesse -- Jesse_Norris ------------------------------------------------------------------------ Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546 View this thread: http://www.excelforum.com/showthread...hreadid=401382 |
Hi Jesse,
You need to multiply the time by 24 to turn it into a decimal. e.g. Total Time Worked + OT =(SUM(H10:H23)+K24)*24 7:40 becomes 7.67 Make sure you format the cells to number with 2dp. HTH - David |
Hi!
7:40 they take it as 7H 24Mins Huh? That makes no sense to me! how i can get 7:40 to display the correct time (7:67) with out starting from scratch? You are already displaying the correct time. 7:67 is not correct! What you probably want to do is, instead of displaying the times in h:mm format, display the times in decimal format: 7.67 To do that, just add a multiplication operation to your formulas: cacluates lunch period =E10-D10 =(E10-D10)*24 total time worked less total lunch =((F10-C10)-G10) =((F10-C10)-G10)*24 total OT for the day =J10-I10 =(J10-I10)*24 Total Time Worked + OT =SUM(H10:H23)+K24 =SUM(H10:H23,K24)*24 Format all of these cells as GENERAL Biff "Jesse_Norris" wrote in message news:Jesse_Norris.1uptua_1125637503.3685@excelforu m-nospam.com... Hi all My payroll officer has pointed out to me that the time sheet i have created is good but i am loosing out on cash because the way they work out the hours is different to the way my time sheet dose, on my time sheet if i work for 7 H and 40 Mins it Displays as 7:40. But here is where i lose out as when the payroll see 7:40 they take it as 7H 24Mins. Dose anyone have a suggestion as to how i can get 7:40 to display the correct time (7:67) with out starting from scratch? the payroll work on the following setup 1min= .02 10mins= .17 15mins= .25 20mins= .33 30mins= .50 40mins= .67 etc. these are my current formulas cacluates lunch period =E10-D10 total time worked less total lunch =((F10-C10)-G10) total OT for the day =J10-I10 Total Time Worked + OT =SUM(H10:H23)+K24 (K24 is the cell containing the total of the over time) this time sheet covers a F/N Thanks in advance Regards, Jesse -- Jesse_Norris ------------------------------------------------------------------------ Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546 View this thread: http://www.excelforum.com/showthread...hreadid=401382 |
Thanks Guys i have been away for a week so sorry i havent responded till now i will give it ago now. Regards, Jesse -- Jesse_Norris ------------------------------------------------------------------------ Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546 View this thread: http://www.excelforum.com/showthread...hreadid=401382 |
| All times are GMT +1. The time now is 02:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com