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!

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

Recent content by michelin

  1. michelin

    Average of Elapsed time

    @Charlyi. never mind. i got it! i used the tree formula trick. thank you very much for your help!
  2. michelin

    Average of Elapsed time

    like I would like to summarize the elapsed time... but i get an error, that this formula can't be summarized.
  3. michelin

    Average of Elapsed time

    I get an error using formula 2 for emin: A number, currenct amount, boolean, date, time, date-time, or string is expected here. Am I doing something wrong? I really really appreciate your answer!
  4. michelin

    Average of Elapsed time

    I don't think i'm following you...calculate minimum of what? maximum of what? would you mind to give me an example using my data? I apologize about any inconvenience.
  5. michelin

    Average of Elapsed time

    I have a difficult time to average "minimum" times: datediff("n",Minimum ({Assigned Time }, {Incident}),Minimum ({AtScene}, {Incident})) I have two incidents: Incident I Unit Time Assigned Time AtScene A 00:05:00 00:06:00 B 00:01:00 00:10:00 Incident II Unit Time Assigned Time...
  6. michelin

    Time Difference Formula

    BettyJ... THANK YOU VERY MUCH!!!!! that worked like a charm :) You made my day!
  7. michelin

    Time Difference Formula

    Thank you Betty, I will try it! Skip, thank you for your response. I really appreciate it! 1.the format is actually date.time, so it contains a date also (i'm just showing times, i'm sorry if it made my example confusing). 2.correct. I have one table. My report is grouped by incident and i'm...
  8. michelin

    Time Difference Formula

    Thank you for your questions! So, I have 2 units that are responding to a call. Unit Time Assigned Time AtScene A 10:25:00 10:30:00 B 10:26:00 10:27:00 I need to know, what is the difference between time first unit assigned and time first unit at scene (I need to know how...
  9. michelin

    Time Difference Formula

    I have following data: Time A Time B 10:25:00 10:30:00 10:26:00 10:27:00 I need to know the time difference between the soonest time from column A and the soonest time from column B (which would be 2 minutes). What formula would you advice to use? I'm...
  10. michelin

    average- time formula

    my highlighted incidents are car incidents (B, D). Incident A is a bike incident. Incident C is blank (doesn't have a type). So I said that if an incident is a car incident then highlight the results. But I don't want this incident to be count in an average. Does this make a sense?
  11. michelin

    average- time formula

    Hi, I need a help to write a formula. I have following data: Incident time difference A 00:02:00 B 00:03:00 C 00:02:00 D 00:06:00 Incidents B and D are highlighter incidents. I need them to stay in my...
  12. michelin

    Sum function

    Hi, this might be very easy but for some reason it doesn't work for me. I have a number fields like 3,2,45,98,107... I need to subtract those numbers (result: 255) but it doesn't work. i tried to use a sum field formula to summarize those number but for some reason it doesn't work. I've got an...
  13. michelin

    Crystal Reports Time formula

    I'm using Crystal Reports v12. I have following data: Unit A Arrived Unit B Arrived Difference 08:29:14 08:29:27 00:00:13 14:11:44 14:11:32 23:59:48 Is there a way how not to get 23:59:48 but of example -00:00:12? Thanks!
  14. michelin

    Navarre report scheduler v5

    I’m currently using report scheduler- Navarre v5. Is there a way how could I schedule a report from SQL view? Thank you! Any advice is appreciated.
  15. michelin

    formula for the data

    I've got it. I add to the header a field from the database {responsedate} and I formated it to see January-2013. :)
See more

Part and Inventory Search

Back
Top