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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bacalaoyalcapurria
  • Order by date
  1. bacalaoyalcapurria

    Time conversion

    Thank you so much. You guys are the best.
  2. bacalaoyalcapurria

    Time conversion

    Thanks but I did that before. If I have this many seconds 257880/ 86400 = 2.984722222 but when I format it using Format Cells I get 23:38 That's not right Is there a way to get the right number. It sure is more than 23 hours. Thanks, Rita
  3. bacalaoyalcapurria

    Time conversion

    Is there a way to change this numbers to hh:mm:ss? These are seconds 292 29 54 286 57840 I'd like to create a column next to the "seconds" column and have Excel to convert the above seconds to hour-minutes-seconds. "00:00:00" Thanks, Rita
  4. bacalaoyalcapurria

    Comparing Dates with a condition

    Thanks for your prompt response. What If I change it to this? Is the syntax alright? Latency: IIf([StartTime]>[ReceivedOn], (DateDiff('s',[Validated],[StartTime]),[ReceivedOn])), DateDiff('s',[Validated],[ReceivedOn])
  5. bacalaoyalcapurria

    Comparing Dates with a condition

    I think it will look like Latency: If CDate([StartTime]) > CDate([ReceivedOn]) then DateDiff('s',[Validated],[StartTime]) else DateDiff('s',[Validated],[ReceivedOn])
  6. bacalaoyalcapurria

    Comparing Dates with a condition

    Hello, I'm doing calculations on date fields and I need to use the if or Iff condition. I've never used it before. Can anybody help me on accomplishing this? Does it have to be done in Visual Basics or can I do it at the query design view? Below are examples on what the data looks like, Start...
  7. bacalaoyalcapurria

    Convert function in Excel

    Hello, I need to convert this 0:12:57 to seconds I'm not sure on how to do it in Excel. I tried doing this =convert(A2,"sec") but I get an error. Thanks, Rita
  8. bacalaoyalcapurria

    Getting an average between two dates

    Thanks. I noticed I'm getting the same result as =TEXT(J2-I2,"h:mm:ss") for example, Beginning Ending 4/13/2006 16:04:29 4/13/2006 16:05:05 Latency ( here I use =TEXT(J2-I2,"h:mm:ss") 0:00:36 Average ( here I'm using =TEXT(Average(J2-I2),"h:mm:ss") 0:00:36 Is that right?
  9. bacalaoyalcapurria

    Getting an average between two dates

    I get this error "You have enter too few arguments for this function
  10. bacalaoyalcapurria

    Getting an average between two dates

    I have two fields like Beginning date ending date 4/13/2006 16:02:29 4/13/2006 16:03:05 I calculated the latency between the two fields by doing this, =TEXT(J2-I2,"h:mm:ss") Now, I'd like to get an average, but I can not seem to get it to work. I tried to do something like...
  11. bacalaoyalcapurria

    Date/time calculation

    I'm very close in getting my result. Right now I'm getting seconds as the result. Received Validated 4/3/2006 8:56:59 PM 4/3/2006 8:57:07 PM 4/3/2006 8:12:25 PM 4/3/2006 8:13:01 PM 4/3/2006 8:48:52 AM 4/4/2006 7:01:02 AM Latency 8 36 79930 Why will not Access let...
  12. bacalaoyalcapurria

    Date/time calculation

    The dates and time are differents. I can't use the DateValue() Function. I have over 500 records and the data is different. An example; Incident Validated, Current Time: 4/3/2006 9:01:01 PM Incident Validated, Current Time: 4/4/2006 12:11:05 PM Incident Validated, Current Time: 4/4/2006 9:19:05...
  13. bacalaoyalcapurria

    Date/time calculation

    I got it using the mid function. Thank you
  14. bacalaoyalcapurria

    Date/time calculation

    Thanks, Is there a better way to extract the date and time from this string; "Problem Validated, Current Time: 4/5/2006 8:01:03 PM" I did this Validated: Right([Alerts].[ValidateStatus],20) but it's not working too well. I just need the date and time
  15. bacalaoyalcapurria

    Date/time calculation

    Hello, I need to do a date/time calcutation with two fields. Find the latency between the two dates and time or just the time. In other words, how long it took the Problem to get validated. Then, I need to get an average. I have to fields 1. Received The information in here looks like...
  16. bacalaoyalcapurria

    Date text boxes in the form __/__/__

    Thanks UnicornRainbow . I'll try that. Thanks so much
  17. bacalaoyalcapurria

    Date text boxes in the form __/__/__

    Thanks for your quick response. I did this (see below )and it seems to be working except for when the first text box (date 1) __/__/__ is populated, one has to tab down in order to go down to the next text box (date 2). I'd like for Access to automatically go to the next text box (date 2)once...
  18. bacalaoyalcapurria

    Date text boxes in the form __/__/__

    Hello, I have a problem with my dates field on a form, I have text boxes that when are clicked, Access puts in this__/__/__ in the text box. I'd like for when a user clicks on the text box, the cursor to start at the very beggining, so in this case the first __/ and not the third __/ and when...
  19. bacalaoyalcapurria

    Lottery ckeck in Excel

    I have a spreadsheet with six columns "A,B,C,D,E,F" and 1000 rows. Numbers is all I have in each column I'd like to be able to search for six numbers. For example, if I type in a cell the following numbers 1-25-33-53-29-7 I want Excel to tell me if those numbers exist within my existing data...
  20. bacalaoyalcapurria

    Why my links will not work in the reports

    Will it work if I create a form instead? Include the links in there and make the form read only. Rita

Part and Inventory Search

Back
Top