Recent content by bacalaoyalcapurria

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