Formula help

[Guest]

I need to have a form and report calculate the diffrence in the time. Here is
an example: Time started = 12:30 Time Ended = 15:40. I need the formula to
give me the diffrence in time (hr.min 3.10). I have been trying to figure
this out for three weeks and it is driving me nuts. Please Help!!

 

[Jim Bunton]

Use DateDiff function see help

I need to have a form and report calculate the diffrence in the time. Here is
an example: Time started = 12:30 Time Ended = 15:40. I need the formula to
give me the diffrence in time (hr.min 3.10). I have been trying to figure
this out for three weeks and it is driving me nuts. Please Help!!

 

[Douglas J. Steele]

See whether http://members.rogers.com/douglas.j.steele/Diff2Dates.html is
what you're looking for.

 

[Guest]

I figured it out about 5 mins after I posted this lol. It was something
really dumb. All I had to do was change the format of one of my feilds from
text to date/time (short date).

Thanks for trying to help!!!