Hours greater than 23

  • Thread starter Thread starter Claire
  • Start date Start date
C

Claire

Hi:

I need my end user to be able to input total hours of more than 23.

My database keeps track of total hours authorized and then based on duration
of appointments, keeps track of hours remaining.

Do I need the hour input to be set up as a number and then (somehow) convert
that value into time?

If I need to convert the number into time, what function would I use? I
can't seem to find a straightforward option.

Thanks In Advance,
Claire
 
If you are measuring a duration of time rather than a point in time, you
should use a number field (integer, double, single,...) rather than a
date/time field.
 
I wondered about that. Probably easier anyway.

Thanks Duane!

If you are measuring a duration of time rather than a point in time, you
should use a number field (integer, double, single,...) rather than a
date/time field.
 
Back
Top