Formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!
 
Use DateDiff function see help

Tigerphoenix said:
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!!
Click to expand...
 
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!!!
 
Back
Top