Search results for query: *

Actually... now that you've talked it out, I'm not sure why i done it that way either. What I ended up doing was taking the data and storing it in a temp table and then append all of the records (including the concatenated field) to a master table. I know that is highly inefficient but it...

Hello, I seem to be beating my head against the wall on something I should know and something I know I've done before. I have a form that takes text box A and concatenates text box B to create text box C. I have the correct concatenation string showing up on the form so i know it's putting...

I have created this statement to change a column from date/time to number and it works... ALTER TABLE [Supplier Workbook] ALTER COLUMN [Total Time Spent] Number but it's keeping the format of "h:nn:ss". Is there a way to add a statement to my query to clear or change the formatting to...

Yep! I'm finally where I need to be. You were spot on Duane. I kept the 24 and removed the 60 and now my durations are nearly perfect. There is a little variation past the 2nd decimal but I'm not too concerned with that. Thanks!

Yes, I would want to convert these to hours because we are trying to justify manpower to hire additional people. Hours would be more meaningful than days.

Ok, I think I'm FINALLY figuring this out. Looking through the forums here, I determined that this number is a seconds calculation. If I take this number and wrap it around this expression, my numbers appear to be correct. Round(([Total Time Spent]*24)*60)] So I think can use this formula...

That number is generated by taking each ticket duration time and converting that field to General instead of Short Time in Excel. If I take that data and import it into Access (or subtotaling in Excel), That would be the grand total of "time" for each location. Part of the reporting I'm...

Ok... how would I convert 49.9263888888357 into a duration? For some reason, I'm drawing a blank.

So while I was waiting for Dhookum's response, I changed the field times to General in Excel, imported that sheet and pointed my Access calculations to that sheet and I got the same numbers that I posted in Access before. To me, that confirms what dhookum said all along. Using the Date/Time...

I'm using 2 expressions to get that calculation in Access: TotalSeconds: (Sum(DatePart("h",[Total Time Spent])*3600+DatePart("n",[Total Time Spent])*60)) TotalTime: Round([TotalSeconds]/3600,0) & ':' & Right("00" & Round((([TotalSeconds]/3600)-Round([TotalSeconds]/3600,0))*60,0),2) Based on...

They are using the NETWORKDAYS function in Excel calculate work days AND work times by using this formula...

Excel Calculates: Location 1 1198:14 Location 2 66:04 Location 3 67:19 Location 4 370:20 Access Calculates: Location 1 1030:14 Location 2 66:04 Location 3 67:19 Location 4 322.20 It's puzzling how it calculates perfectly for Locations 2 and 3 but 1 and 4 are off.

Which way is "correct"? I'll need to justify my calculations and why they aren't the same as Excel. How could I mimic the Excel calculation for Access? Is it possible?

Hello all, I'm struggling trying to find out why Access is calculating time durations on certain data differently than Access. Here's my story... There is data in a spreadsheet that looks at time duration based on the NETWORKDAYS code and gives a duration of how long a ticket has been open...