Re: Excel (1457331) | |||
Home > SubChat | |||
[ Read Responses | Post a New Response | Return to the Index ] |
|
Re: Excel |
|
Posted by BusRider on Thu Dec 7 10:56:43 2017, in response to Re: Excel, posted by Bill West on Thu Dec 7 01:26:02 2017. Thank you again, So far the first formula still works with the 7:55.The second set of formulas, I will give it a try later. This is the second problem I'm working on: J1 = 5:00 J2 = 5:10 J3 = 12:30 K4=SUM(J3-J1) = 7:30 J5 = 15:10 11th Hour of Work J6=J2+11/24 = 16:10 J7 = 20:00 K6=SUM(J6-J5) = 1:00 K7=SUM(J7-J6) = 3:50 Straight K8=MROUND(SUM(K4,K6),1/96)*24 = 8.5 (7:30 + 1:00 = 8:30) Overtime K9=MROUND(K7,1/96)*24 = 3.75 (3:50) But K8 ST is supposed to be 8 and K9 OT is supposed to be 4.25 |