Hour / Minutes Format

  • Thread starter Thread starter Tofer471
  • Start date Start date
T

Tofer471

Hello All,

I am trying to create a field format of Hours / Minutes that is used for
logging time length. The problem that I am having is that all time formats
seem to keep placing/saving the data as AM/PM, etc. Is there any format that
can be just used for Hours / Minutes that does not relate to a time?

Thanks in advance
 
Tof:

No, there's no simple hours/minutes format. You can simply use a field
based on a single to store fractional hours. (easiest in 15 minute
increments) or separate the hours and minutes into separate fields. If you
want a single field then you might try on your form having a start time and
end time and then using DateDiff, determine the total minutes between the
two and store that figure as a long number. That way when doing
calculations you can simply divide by 60 to get to whole hours and minutes.
 
Back
Top