Time Greater Than 24 Hours

  • Thread starter Thread starter Gerald
  • Start date Start date
G

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.
 
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
 
Gerald said:
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.
Click to expand...

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)
 
Back
Top