Thread: Calculate After hours
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Calculate After hours
Hi,

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

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.

then try:
=IF(B10.75,B1-0.75,IF(A1=0.75,MOD(B1-A1,1),""))


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Professional
Reply With QuoteReply With Quote