concurrent

Hello, I am trying to plot a bunch of time series via a macro I've written. When the column of data are NOT concurrent (like Range("A:A") and Range("C:C")), it works fine. However if I want to plot Range B s Range A (timestamps in A, data in B), then the graph comes out all messed up (all...

Please help. Looking for an equation that will calculate the Max concurrent rooms in column D between each start and stop date/time. Column D has what the correct answer would be. If possible would also like the MIN in column E which also has the correct answer. Correct answers are included to...

hi guys, New to the forum. However been referring to this forum from general google searches for years now. Seems today im at an impasse for a new problems which is quite specific. I've no doubt heads will be scratching. I need to be a manner in which I can determine the number of concurrent...

Hi All, I'm trying to figure out how many concurrent users there are in office for each day. Column A is Check-in date and time, and Column B is Check-out date and time. Every row is an individual. For example, <tbody> Employee Check-In Date & Time Check-Out Date & Time Employee 1...

Hello, I have x number of sessions occurring noted by start times in column A and end times in column B in the format of "mm/dd/yyyy hh:mm". Here is a sample of the data sorted by oldest time in column A first: 8/31/2015 22:01 8/31/2015 22:24 8/31/2015 22:01 8/31/2015 22:27 8/31/2015...

I need to know the maximum amount of concurrent transactions (calls, employees, etc.) that are happening during each transaction by minute and report that maximum for each transaction. My thought is to create a function where I can pass a start date/time, end date/time, a range of potentially...

I have a macro in an excel 2007 worksheet that does timed alerts and works great (one at 30minutes, one at 45 minutes and a third at 90 minutes. The macro is started by a checkbox. However I also need to simultaneously have have a visual timer also once the checkbox is checked. I have created...

We are moving from Office 2002 to Office 2007 (big leap of faith!), and I have been chosen as the guinea pig. For compatibility with my colleagues, I would still like to use 2002 (specially Excel) while I am testing 2007 and porting our template files across. Can Office 2007 be installed so...