Calculate Elapsed M-F 8 to 5 hours

[evan from N]

i need to show amount of work week time (M-F 8-5) that has elapsed from a certain time. Thanx for help.

[Ender]

How about a little hint about how your database is structured??

[evan from N]

database has a date and time that a request has been placed.

i wish to calculate an event's work week hours from that date and time.

structure wise, i have some lookup's and some relational information, but that isn't related much to the calculation need.

A=Day and time start

B=Day and time event

C=Minus Friday 5:00PM to Monday 8:00AM Elapsed Time

B-A=C

Edited October 5, 2007 by Guest

[Ender]

Okay, you want to be vague? Just do a Sum() of the related event records. Or, if you like summary fields, Find your records in the event table, then use a sub-summary report with a Summary (Total) of the elapsed time.

If you want specifics, I'd need a lot more details (my crystal ball is on the fritz). Give details about what the structure is (tables and fields, and how the tables are related), what the data looks like, and where you wanted to see the results. Maybe post a screenshot of the relationship graph, or better yet, a clone of the file you're working on.

[David Jondreau]

Ender may be coming across as a little snarky, but he's right. We've all had the experience of replying to a question with scant details to find that the particulars of the details make the answer irrelevant. Provide as much details as you can and you'll get a much better response.

[comment]

I don't know, the question seems clear enough to me: essentially, it's how many work hours are there between two timestamps. Unfortunately, I don't have a simple answer to that, and the elaborate one is rather obvious.

[evan from N]

Am i not in calculation forum?

is a calculation not a type of field?

i do not want any help with a database.

i want a formula for a calculation.

any variable symbol will work i am not brain dead.

i am of the mindframe that someone has created a custom function. isn't that specific enough?

annoying.

[evan from N]

i shoulda had lotus corp install an obsfucation filter in my pre-odbc schema

[Lee Smith]

simmer down young man

There are probably hundreds of posts about working with Elapsed time that has been posted here, Also, JMO of Database Pros has some examples on his site, that show this too. Do a search for the Keywords of Elpase Time, and you should find what you are looking for.

You don't say how the results are to be displayed, i.e. days, hours, months, or a combination of them. I posted a CF in the Sample files and that was a conversion of a Tech Article at FileMaker Inc.

HTH

Lee

Edited October 5, 2007 by Guest
Batterie going low

[comment]

You ARE in the Calculations section. However, your profile does NOT indicate the Advanced version, so members are not quick to offer a solution requiring a custom function.

I don't recall seeing a CF for this. I have played with this myself, but it's not yet something I would want to publish. However, if your points in time are always on a work day, you can simply calculate the number of elapsed work days, multiply by 9, and subtract the two time differences.

[evan from N]

i greatly appreciate all time afforded to point me in right direction. i am seaching CF's i might be able to find. i hope to track hours.

of course it gets more complicated.

thank you all

[Ender]

i shoulda had lotus corp install an obsfucation filter in my pre-odbc schema

I think you've already got an obfuscation filter going on in this thread.

Anyway, it's a good thing we've got our friend comment around to get to the bottom of things. He's our resident 'Amazing Kreskin' you know. :clap:

[comment]

Yeah, right. If you knew how many of them zoom right by me...