Recent content by erummel

I know this sounds dumb, but where would I put those additional expressions? I currently have this as my expression: MTTR: DateDiff('n',[Outage Start],[Outage End])/60 Would I add those two lines to the end of that? In a different field?

So if I am understanding correctly, my expression is returning exactly what it should: 2.6666667 hours. It sounds as if I may out of luck as far as an easy way to convert to the format I need of hours and minutes by the dreaded 'Access cannot handle timespans over 24 hours' issue. I usually have...

So, using DateDiff, I have come up with: MTTR: DateDiff('n',[Outage Start],[Outage End])/60 The result for a record which should be 2:40 is returned as 2.666666666666667. When I apply the h:nn format to the field, the result is returned as 16:00. Same thing happens when I export to excel and...

I've written an expression within a query to do a time/date calculation and report the result with a bunch of other data I've pulled. The expression works great and does exactly what I ask of it. However, my superiors would like the data returned in a slightly different format. My expression is...

WOW!!!!!!!!!!!!!!! That worked like a charm! Thank you so much, it's super appreciated!!!!

The data includes a date and time, in a custom format: e.g. 05/30/2014 17:47 That's the format for both the start and end fields.

Hi All, Let me preface this with I don't even know if this is possible... I am needing a query to calculate elapsed time in business hours for each record selected (I normally base this on a date range). For the purposes of this query, business hours are defined as Mon-Fri from 7 AM until 9...

Does anyone have any suggestions on where I actually put the string referenced above?

I know this may sound silly, but I don't know where to use this construct. I have tried pasting this into the Expression Builder, replacing [range to] and [range from] with my actual field names, but I get an error returned saying that the above expression cannot be used in a calculated column...

Hi, I'm new to Access (like thousands of others here :banghead:) and am having an issue with Access not liking to display elapsed time over 24 hours correctly. My original expression for this field was [Outage End] - [Outage Start]. I kept the result type as Date/Time but used a custom Format...