Calculate After hours


O

office

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!
 
Ad

Advertisements

C

Claus Busch

Hi,

Am Tue, 1 Apr 2014 10:10:37 -0700 (PDT) schrieb (e-mail address removed):
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(B1>0.75,B1-0.75,"")


Regards
Claus B.
 
O

office

Hi,



Am Tue, 1 Apr 2014 10:10:37 -0700 (PDT) schrieb (e-mail address removed):







try:

=IF(B1>0.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!
 
Ad

Advertisements

C

Claus Busch

Hi,

Am Tue, 1 Apr 2014 10:34:35 -0700 (PDT) schrieb (e-mail address removed):
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(B1>0.75,B1-0.75,IF(A1>=0.75,MOD(B1-A1,1),""))


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top