Time Greater Than 24 Hours

[Gerald]

I am making a Timesheet Database for my employer. Employees can get Comp
Time which can accrue to 40 hours or more. All the formulas and formatting
that I have tried stop the clock at 24 hours. Is there a way that I can have
the database allow time to accrue to more than 24 hours and show correctly.

 

[Jeff Boyce]

Gerald

I suspect you're finding out that a Date/Time field is better used to store
a date/time value (i.e., a point in time), rather than a duration (i.e., "6
hours"). If you have that field as a Date/Time data type, even if you have
it formatted to only display the time portion, you still have point-in-time
values.

If you need to add up "hours", don't use Date/Time! Instead, use, say, a
numeric field data type.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mr. B]

Here are a couple of links that might help:

http://www.mvps.org/access/datetime/date0004.htm

http://www.mvps.org/access/datetime/date0008.htm

http://www.mvps.org/access/datetime/index.html

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[James A. Fortune]

I am making a Timesheet Database for my employer. Employees can get Comp
Time which can accrue to 40 hours or more. All the formulas and formatting
that I have tried stop the clock at 24 hours. Is there a way that I can have
the database allow time to accrue to more than 24 hours and show correctly.

Use the Date/Time format, but include the Date part, not just the time
part with each In or Out time. That way, functions like DateDiff() can
calculate periods longer than 24 hours and periods that cross midnight(s).

James A. Fortune
(e-mail address removed)