Straight time and overtime question

[all7holly]

Hello,

I would like to calculate straight time and overtime in a query. The names of the fields are “Hours” and “LunchAndUnPaidTimeOff”. Any ideas how I can show if a person has worked 40 hours or under and how many overtime hours after the 40 worked hours?

 

[plog]

I have a few ideas but I am going to need some sample data from your table to verify how its being put in. Can you provide some sample data and then what you expect the result to be based on that sample data?

 

[all7holly]

If an employee has the following.
.5-hour lunch
45.16-hours
Worked hours minus lunch=44.66
StraightTime should be 40
OverTime should be 4.66

 

[all7holly]

Thanks for you help.

 

[plog]

If its all in one record then you simply calculate it similar to what you would do in a spreadsheet.

What have you tried exactly? Where are you getting stuck? What's your SQL look like?