Calculating duration for business hours
I have a formula where it is tracking how long does a rep stay on a current status. I'm using the following formula to calculate this but it seems like it is also including the hours during the non...
Forum Discussion
Hello Endy,
It sounds like you want this duration field to stop at 6pm regardless of whether or not they have populated the [Time Stamp At lender] field. I believe that would require adding a condition that states: If Now() => 6pm and [Time Stamp At lender]="", 6pm - [Date Created].
If you'd like I'd be happy to find 30 minutes tomorrow to help you think through this. Feel free to send me a note with some times that work
------------------------------
Freddie Sabbs
Senior Solutions Consultant
Quick Base
fsabbs@quickbase.com
Cambridge MA
------------------------------
It sounds like you want this duration field to stop at 6pm regardless of whether or not they have populated the [Time Stamp At lender] field. I believe that would require adding a condition that states: If Now() => 6pm and [Time Stamp At lender]="", 6pm - [Date Created].
If you'd like I'd be happy to find 30 minutes tomorrow to help you think through this. Feel free to send me a note with some times that work
------------------------------
Freddie Sabbs
Senior Solutions Consultant
Quick Base
fsabbs@quickbase.com
Cambridge MA
------------------------------
