Adding Hours worked
I need to set up a calculated sheet that will add the before lunch hours with
the after lunch hours, then divide by the 24 hour clock |
Adding Hours worked
http://www.cpearson.com/excel/overtime.htm
-- Kind regards, Niek Otten "randeerae" wrote in message ... I need to set up a calculated sheet that will add the before lunch hours with the after lunch hours, then divide by the 24 hour clock |
Adding Hours worked
I had the same problem and this is the way I did it:
(Time out before Lunch - Time in befor lunch)*24 + (time out after lunch - time in after lunch)*24 This will give you a total in decimal for the whole day Hope I was helpfull Regards "randeerae" wrote: I need to set up a calculated sheet that will add the before lunch hours with the after lunch hours, then divide by the 24 hour clock |
All times are GMT +1. The time now is 07:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com