Taken
New Member
Hi,
Just registered for this forum and this will be my first post.
I am working on a sheet that calculates my working hours with overtime and all.
My sheet looks like this:
Column B is my starting time in the morning.
Column C is my end time in the evening.
Column D is supposed to calculate how many "ordinary" work hours I have that day.
The way I have setup D now is: =(C4-B4)*24-0,5
-0,5 is for my 30 minutes break which I don't get paid for.
This gives me a total amount of hours for the whole day minus the break.
So for Monday for example this formula gives me the total amount of 10,38 hours.
I am getting paid overtime after 9,5 hours.
What I want to do is have column D calculate the total hours and print out 9,5 in column D for the ordinary paid hours or a lower value if I haven't worked the full 9,5 hours, I then want it to take the value that exceeds 9,5 and print that out as overtime hours in column E.
So in this example it would print out 0,88 in column E and 9,5 in column D.
Is this possible to do?
As of now I have the current fomula in column E: =IF((C4-B4)*24-0,5>9,5;(C4-B4)*24-0,5-9,5;"0")
Hope someone can help me out here!
Thanks in advance!
Regards
Just registered for this forum and this will be my first post.
I am working on a sheet that calculates my working hours with overtime and all.
My sheet looks like this:
Column B is my starting time in the morning.
Column C is my end time in the evening.
Column D is supposed to calculate how many "ordinary" work hours I have that day.
The way I have setup D now is: =(C4-B4)*24-0,5
-0,5 is for my 30 minutes break which I don't get paid for.
This gives me a total amount of hours for the whole day minus the break.
So for Monday for example this formula gives me the total amount of 10,38 hours.
I am getting paid overtime after 9,5 hours.
What I want to do is have column D calculate the total hours and print out 9,5 in column D for the ordinary paid hours or a lower value if I haven't worked the full 9,5 hours, I then want it to take the value that exceeds 9,5 and print that out as overtime hours in column E.
So in this example it would print out 0,88 in column E and 9,5 in column D.
Is this possible to do?
As of now I have the current fomula in column E: =IF((C4-B4)*24-0,5>9,5;(C4-B4)*24-0,5-9,5;"0")
Hope someone can help me out here!
Thanks in advance!
Regards
