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 Bill West on Thu Dec 7 01:26:02 2017, in response to Re: Excel CORRECTION, posted by BusRider on Wed Dec 6 21:02:11 2017.

If you mean you now have C8=IF(AND(C5<"8:00",C5>"8:00"),0,MROUND(C5-"8:00","0:15")*24), I think it will still stall when C5 is 7:55. Maybe I'm not correctly following your update.

C7=IF(C5>0,"8:00",0) and C8=MAX(C5-"8:00",0) should separate the straight time and overtime.

Bill

Responses

Post a New Response

Your Handle:

Your Password:

E-Mail Address:

Subject:

Message:



Before posting.. think twice!


[ Return to the Message Index ]