View Full Version : Calculating Time


ScottInWine
05-05-2000, 08:42 AM
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
05-05-2000, 07:35 PM
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
05-06-2000, 06:31 AM
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).]