Search results for query: *

Thank you so much. You guys are the best.

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

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

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])

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

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...

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

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?

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

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...

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...

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...

I got it using the mid function. Thank you

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

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...

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

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...

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...

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...

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