Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Time Formulas

Status
Not open for further replies.

aztrish

Technical User
Jul 9, 2008
2
US
I work in the EMS field, we have been using Approach for years for a report that gives a calulation of response times.
We had a problem and had to erase the file and start again this year, now using the formula the same way as before doesn't seem to work.

This is what I have in field definition formula/options now.

TextToTime("On Scene" - Received)

We have another report that calculates enroute times and the formula is almost identical and works perfectly.
Any idea why the formula won't work?

-Trish
 
I would need to know the value of "On Scene" and "Received" and whether they are text or time values???

Sue Sloan
 
Sue,I fixed it! I had the field properties wrong. It clicked when I was trying to explain it to you! lol

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top