By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,149 Members | 885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,149 IT Pros & Developers. It's quick & easy.

Need Help with Calculated field

P: n/a
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
Dec 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tue, 12 Dec 2006 18:36:59 -0500, Steve Harp <No****@NoPlace.com>
wrote:
>Can this be done in a calculated field? If not, what is the best way
to address this issue?

Thanks for any help,
Steve
Sorry, wrong group...
Dec 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.