Overtime Calculation???
Help!!! I can't workout how to do an overtime calculation if a standard day was 7.5 hours (7 1/2 hours) and they work on a bank hol I want it to state that they have worked double time in hours worked that day?? -- Cherilou ------------------------------------------------------------------------ Cherilou's Profile: http://www.excelforum.com/member.php...o&userid=36371 View this thread: http://www.excelforum.com/showthread...hreadid=561540 |
Overtime Calculation???
http://www.cpearson.com/excel/overtime.htm
try this hth regards from Brazil Marcelo "Cherilou" escreveu: Help!!! I can't workout how to do an overtime calculation if a standard day was 7.5 hours (7 1/2 hours) and they work on a bank hol I want it to state that they have worked double time in hours worked that day?? -- Cherilou ------------------------------------------------------------------------ Cherilou's Profile: http://www.excelforum.com/member.php...o&userid=36371 View this thread: http://www.excelforum.com/showthread...hreadid=561540 |
Overtime Calculation???
Hi, Ahh... What I want maybe didn't explain properly(usual). I have a drop down box in a cell to say if it's a Bank Hol and it automatically calc's that day as a normal hour working day, when I don't add the time in and out but I want it to calculate if it's a bank hol the hours put in if is worked... I have attached what I've been working on if anyone can help +-------------------------------------------------------------------+ |Filename: Opt Time Sheet.pdf | |Download: http://www.excelforum.com/attachment.php?postid=5044 | +-------------------------------------------------------------------+ -- Cherilou ------------------------------------------------------------------------ Cherilou's Profile: http://www.excelforum.com/member.php...o&userid=36371 View this thread: http://www.excelforum.com/showthread...hreadid=561540 |
All times are GMT +1. The time now is 01:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com