What would the formula be to add (total) all the time accumulated for one client. And them make the formula client selective.

What would the formula be to add (total) all the time accumulated for one client. And them make the formula client selective.

Your situation depends on how time is being entered. First, a time entry should be related to a specific Client ID. Second, the time has to be numerical to be added. Third, time can be entered in "time" format (hh:mm, e.g., 05:35) or in decimal format (hh.hh, e.g., 1.25 hours). Decimal format is typical in professional billing in 15-minute increments. Fourth, is total time for a single entry being computed from a "start" time and "finish" time or is just total time being entered for that single entry?

The general formula is:

"Time" format:

Convert minutes to numbers

Convert hours to numbers

Add minutes

Add hours

Divide total minutes by 60

Remainder is total minutes

"Carry" whole quotient to total hours

Example: 4 hours, 277 minutes

277 minutes divided by 60 = 4 hours 37 minutes

Add 4 hours to 4 hours

Total time: 8 hours 37 minutes

Decimal format:

Add decimal times as numbers

If you need to compute time elapsed between "start" and "finish" times ("time" format):

Convert each time to "24-hour" time

Convert each time to total minutes ( (hours x 60) + minutes )

Subtract finish time from start time

Convert back to elapsed time

Divide elapsed minutes by 60

Whole quotient is hours, remainder is minutes

Example: Start 7:45AM, Finish 2:20PM (=14:20)

7:45 = 465 minutes, 14:20 = 860 minutes

860 - 465 = 395 minutes

395 minutes = 6 hours 35 minutes

(If you are crossing midnight, then add 24 hours to finish time:

Example: Start 11:40PM, Finish 3:30AM

Start = 23:40, Finish = 27:30)

Hope this helps.

In order to compute elapsed time, you need only do this unless "start" and "Stop" might be on the opposite sides of 12 midnight:

Stop - Start

This produces elapsed time in seconds and if you choose a time result type, you can format the result in HH:MM:SS format if desired.

To get that as a number in hours:

(Stop - Start ) / 3600

If Start and Stop might start in one day and stop in another, use timestamp fields and then the above calculation will work even in that case, but now you have to specify a date as well since such a format could compute elapsed time spanning multiple days.

I manually enter these times and a decimal basis. There is no outside time management system.

My goal is to create a query action similar to our "Time Lookup" (where I can summarize specific individual's time) to one where when I select a JOB NAME I would be able to select a job and that job's TOTAL HOURS over the 17000 plus time sheets would be added together and summarized.See this KB (knowledge base) article for the discussion on "Portals & Repeating Fields":

http://help.filemaker.com/app/answers/detail/a_id/7462/kw/repeating or related/

spaulson:

Thank you for your post!

I wonder if a Summary Field and Sort might get you started on this.

Additonally, I'm going to move this thread from the FileMaker Community Feedback Space (which is specifically for input on the Community itself) to the Discussions Space where you should receive more views and potentially more feedback on this topic!

TSPigeon

FileMaker, Inc.