What would the formula be to add (total) all the time accumulated for one client. And them make the formula client selective.
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!
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:
Convert minutes to numbers
Convert hours to numbers
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
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.
And what problem are you having computing that total. What I see is time strictly entered as time in hours which makes this simply a case of computing a total.
Are you using repeating fields or a portal to a related table for this data? (Repeating fields are not a good idea here.)
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/
Retrieving data ...