Calculate After hours
 

Hi There!

I am having a bit of trouble while creating a formula,
It goes like this:

FIELDS:
A - (START TIME)
Value: Let's say (7 am)

B - (FINISH TIME)
Value: Let's say (10 pm)

C - After hours (consider hours past 6 PM after hours)
Result is (4)

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

What would the formula look like??
Thank you very much!

Calculate After hours
 

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

Calculate After hours
 

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!

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