Shift hours logic

Yahoo Archive
1
It does this in the labor tables but not on the shift table. I just want to list out my shift and the associated hours.

I'll give this equation a try.

Thanks!
Jasper

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Sean McDaniel
Sent: Tuesday, November 10, 2009 4:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Shift hours logic



I seem to recall that Epicor already subtracts the lunch time from the total
time. Are you sure you need to do this?

Wouldn't this work?

If (lunchstart > noon) and (lunchend < noon) then (lunchend - 12
hours)-(lunchstart - 12 hours)

Else

Lunch end - lunch start

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Jasper Recto
Sent: Tuesday, November 10, 2009 2:00 PM
To: Vantage Groups (vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] Shift hours logic

Can anybody help me come up with an equation that can give me the shift
hours and lunch hours from the shift table.

Simply subtracting Endtime - Starttime does not work on my night shifts.
Also, it does not work for the lunch hour if it goes past midnight.

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
Can anybody help me come up with an equation that can give me the shift hours and lunch hours from the shift table.

Simply subtracting Endtime - Starttime does not work on my night shifts. Also, it does not work for the lunch hour if it goes past midnight.

Thanks,
Jasper



[Non-text portions of this message have been removed]
3
I seem to recall that Epicor already subtracts the lunch time from the total
time. Are you sure you need to do this?



Wouldn't this work?

If (lunchstart > noon) and (lunchend < noon) then (lunchend - 12
hours)-(lunchstart - 12 hours)

Else

Lunch end - lunch start



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Tuesday, November 10, 2009 2:00 PM
To: Vantage Groups (vantage@yahoogroups.com)
Subject: [Vantage] Shift hours logic





Can anybody help me come up with an equation that can give me the shift
hours and lunch hours from the shift table.

Simply subtracting Endtime - Starttime does not work on my night shifts.
Also, it does not work for the lunch hour if it goes past midnight.

Thanks,
Jasper

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]