On Tuesday, April 1, 2014 1:18:18 PM UTC-4, Claus Busch wrote:
Hi,



Am Tue, 1 Apr 2014 10:10:37 -0700 (PDT) schrieb :



Statement:

If working hours are past 6PM, then calculate after hours, if working hours are not past 6 pm do not calculate it.



try:

=IF(B10.75,B1-0.75,"")





Regards

Claus B.

--

Vista Ultimate SP2 / Windows7 SP1

Office 2007 Ultimate SP3 / 2010 Professional

Hi Claus!
When A is equal or greater than 00:01AM and B is equal or lesser than 11:59PM it works, Although, I'd like to use A as reference when working hours passes midnight to keep counting. Let's say someone is working from 10:00 PM to 01:00 AM, the code does not recognize the calc. The result was supposed to be 3.

Thanks once again!