S
Steve Harp
Hi All,
I'm not sure this can be done in a calculated field but here's what I
need. I have a table that stores time off for employees (such as
vacation, sick time, etc). An employee can take partial days off. The
table has 2 datetime fields, StartDate and EndDate that store the
beginning and end of the time off. Of course, the difference between
StartDate and EndDate might span several days or weeks. The company
works an 8 hour day from 08:00 AM to 05:00 PM with 1 hour off for
lunch.
I'd like a calculated field which can give me the days of vacation or
whatever used. For instance, if an employee takes off from 8 AM until
2:30 PM (5.5 hours not counting lunch) on one day, the field should
return .6875 days. If an employee takes off from 8 AM Monday until 5
PM Friday, the field should return 40.
Can this be done in a calculated field? If not, what is the best way
to address this issue?
Thanks for any help,
Steve
I'm not sure this can be done in a calculated field but here's what I
need. I have a table that stores time off for employees (such as
vacation, sick time, etc). An employee can take partial days off. The
table has 2 datetime fields, StartDate and EndDate that store the
beginning and end of the time off. Of course, the difference between
StartDate and EndDate might span several days or weeks. The company
works an 8 hour day from 08:00 AM to 05:00 PM with 1 hour off for
lunch.
I'd like a calculated field which can give me the days of vacation or
whatever used. For instance, if an employee takes off from 8 AM until
2:30 PM (5.5 hours not counting lunch) on one day, the field should
return .6875 days. If an employee takes off from 8 AM Monday until 5
PM Friday, the field should return 40.
Can this be done in a calculated field? If not, what is the best way
to address this issue?
Thanks for any help,
Steve