Hello,
I have a simple file where i put my times for work and the overtime. It looks like this:
2017-10-26 14:00-23:00 (30)
(30) is the overtime. I want a code that writes this for me. So the standard-time is 14:00-22:30 and any deviations from this will show in another column.
1. Key the standard end time (22:30) into a cell on your worksheet (I used A1 to test this).
2. Assuming your end time is in column C, use the following formula.
.
I took a different approach. Assuming you are paid for 8 hours work regular time with a 30 minute meal break. So anything over 8.5 hrs is overtime.
Also assuming you are willing to change the format you enter your times ... from 14:00 ... change to 14.00 or instead of 23:30 ... change to 23.5
(a quarter hour would be .15 ...... 3/4 hour would be .45)
Excel 2007 32 bit [TABLE="class: head"]
<tbody>[TR="bgcolor: #888888"]
[TH][/TH]
[TH]
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
