Field to display hours and minutes

[burrina]

I am trying to make a field in my table for hours and minutes, can this be done?
Here is the info. Field Name is tme and it is date/time format with a format of hh\,nn
So, I would like to be able to enter the hours and minutes in this field, do I have to make two fields for this? If so what is the format I would choose for each field? To be clear, I want to be able to enter the hours and minutes I want in this field.

[Missinglinq]

Just to clarify are you

Trying to enter a 'Time' as in 1:30pm in the afternoon

or are you

Trying to enter 2 hours and 45 minutes, as in "It took 2 hours and 45 minutes to complete the assigned task?

Linq ;0)>

[burrina]

Yes, 2 hours and 45 minutes is what I am after.

[Missinglinq]

First off, this/these Field(s) should not be Date/Time Field(s). A Date/Time Field is used to pinpoint a specific point in time, such as January 19, 2013 @ 1:30pm.

Fields to represent hours and minutes, as in 'the number of hour(s) and minute(s) it takes to accomplish a task, are just that, Numbers, and the Field should be defined as such, at the Table-level.

You can either simply

• Have two Controls/Fields, for entering the hours and minutes
• Have a Control for entering the total number of minutes, then use code to populate an Hour Field and a Minute Field.

Code would be something like this:

Private Sub txtEnterTotalMinutes_AfterUpdate()
 Me.txtHours = txtEnterTotalMinutes \ 60
 Me.txtMinutes = txtEnterTotalMinutes Mod 60
End Sub

Linq ;0)>

[burrina]

Thank you, I will adjust my table fields and give this a try.

[burrina]

Okay, now I need the end result. I added the fields txtHours and txtMinutes to my table and set them to a number. Now on my form I have 8 hours (txtHours) and 45 minutes (txtMinutes) for both the fields. I have an unbound field that I need to total this out in. Add the the total hours and minutes as a final result. Unbound field is named txtresult