Subtracting Time

[Drum2001]

I have a table that contains the following fields:

ItemName // Name of Assignment
AvgTime //Estimated number of mins to complete

I have a form that has a combo box listing all assignments (Record
Source: ItemName)
This form also contains three textboxes [Hours] and [Mins] and
[NumberOfCompletions]

When the user updates the [NumberOfCompletions] field I have the
[Hours] and [Mins] Textboxes calculate the time it took based on the
AvgTime.

Example [NumberOfCompletions] * [AvgTime] = [Mins] ; 2 Completions * 15
AvgTime = 30 mins...

Not too complex.

I have it calculating the hours with the following code:

Me.Mins = Me.AvgTime * Me.NumberOfCompletions
If Me.Mins 59 Then
Me.Mins = Me.Mins - 60
Me.Hours = Me.Hours + 1
Else
End If

This works great if I do increments by "1". However, sometimes I may
want to put in 45 completions. Obviously incrementing the "Me.Hours+1"
would not work anymore.

Are there any special functions or commands that would do the division
and give me the integer part and then calculate the mins based on the
remainder?

Any suggestions would be greatly appreciated!

Thank you!

Brad

[Drum2001]

I FIGURED THIS OUT. PLEASE DISREGARD!
Drum2001 wrote:

I have a table that contains the following fields:

ItemName // Name of Assignment
AvgTime //Estimated number of mins to complete

I have a form that has a combo box listing all assignments (Record
Source: ItemName)
This form also contains three textboxes [Hours] and [Mins] and
[NumberOfCompletions]

When the user updates the [NumberOfCompletions] field I have the
[Hours] and [Mins] Textboxes calculate the time it took based on the
AvgTime.

Example [NumberOfCompletions] * [AvgTime] = [Mins] ; 2 Completions * 15
AvgTime = 30 mins...

Not too complex.

I have it calculating the hours with the following code:

Me.Mins = Me.AvgTime * Me.NumberOfCompletions
If Me.Mins 59 Then
Me.Mins = Me.Mins - 60
Me.Hours = Me.Hours + 1
Else
End If

This works great if I do increments by "1". However, sometimes I may
want to put in 45 completions. Obviously incrementing the "Me.Hours+1"
would not work anymore.

Are there any special functions or commands that would do the division
and give me the integer part and then calculate the mins based on the
remainder?

Any suggestions would be greatly appreciated!

Thank you!

Brad