Calculating Time

[ScottInWine]

I need to calculate the net hours between a start time and an ending time. For example, a user enters 6:00 for a start time, and 7:30 for an ending time. I need to perform a calculation on the form to fill in a field to show 1.5 hours. I'm going in circles with the help..... and need help! Thank you!

 

[Carol]

Make sure that your StartTime and EndTime are formatted to Short Time. Create an unbound text box and in the control source of this text box place the following:
=[StartTime]-[EndTime]
Make sure that this unbound text box is also formatted for short time.

Good Luck

 

[R. Hicks]

Insert a txtbox for this result on your form. In the control source of this txtbox add:

=([EndTime]-[StartTime])*24

"EndTime" and "StartTime" needs to be the names of your controls.

HTH
RDH

[This message has been edited by R. Hicks (edited 05-06-2000).]