Time calculation

[Rainy Pass]

Calculation field will not show correct time. I have one calc field (Task_time) that calculates the time of a task (End time

[-Queue-]

If you want to use a summary field in a calculation, it's probably best to use GetSummary( sumfield, breakfield ) and sort by the break field.

[Rainy Pass]

GetSummary will require a script for the sort. Any ideas to accomplish this without scripting.

I may be trying to hard but, scripts usually mean another button and another step for the user. I am trying to make this as simple as possible for the user. I want the time card system to be a no brainer. I am trying to keep this to a one and/or two step interface.

[-Queue-]

Perhaps I read your original post incorrectly. Are you using a summary field or a calculation field that use Sum( ) to add up the totals for related records?

[Rainy Pass]

A calc field totals the time for each event in the data table.

A summary field totals the times for each day using a self join relationship.

I was trying to build a calc field to add and display a fixed value to the sum total.

I am trying to calculate break times based on the hours worked in a day.

I have not built any complex solutions for a couple years and am using this file to attempt to get up to speed. Unfortunately I am very rusty and finding it difficult to bridge the gap between the possibilities of 7 and the reality of my level of expertise. Admittedly my approach may be all wrong.

I appreciate the help.

[-Queue-]

I'm assuming your self-join relationship uses both employee and date to determine matches. Is this correct?

[Rainy Pass]

Yes. the relationship uses global emp and date fields to normal emp and date fields.

[-Queue-]

Aha! The global fields are your problem. Make your self-relationship based on the Employee and Date that are specific to each record, not global fields that would be related to the same records regardless of which record you are on.

[Rainy Pass]

Why am I scepticle this isn't going to entirely work for me?

I'll give it a go next week and see.

Thanks for your help, much appreciated.