Home  Maps  About

Home > SubChat
 

[ Read Responses | Post a New Response | Return to the Index ]
[ First in Thread | Next in Thread ]

 

view flat

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

Responses

Post a New Response

Your Handle:

Your Password:

E-Mail Address:

Subject:

Message:



Before posting.. think twice!


[ Return to the Message Index ]