Find Out Total Duration Logged In
Oct 18, 2009
is it possible to calculate the total duration of logged in from the data below?
TimeDateTimeExtCoDial Number08:02:00 AM11/10/200908:02AM203LOG IN08:03:00 AM11/10/200908:03AM2033448249908:05:00 AM11/10/200908:05AM207LOG IN08:05:00 AM11/10/200908:05AM132102445477708:08:00 AM11/10/200908:08AM207102445477708:11:00 AM11/10/200908:11AM1322908:11:00 AM11/10/200908:11AM1323008:12:00 AM11/10/200908:12AM2073008:12:00 AM11/10/200908:12AM2032908:13:00 AM11/10/200908:13AM132202631121108:14:00 AM11/10/200908:14AM203LOG OUT
Column 'A' has the time and extn# on column 'D' and indication of logged in or logged out on column 'F'
there can be several log in and log out by an extn.
View 9 Replies
ADVERTISEMENT
Feb 17, 2009
I want to find out who is logged on when running my macro.
View 2 Replies
View Related
Oct 2, 2008
Is it possible to have a MsgBox that would say "Hello" to the user who is logged in on that computer. How would you reference the user info?
View 4 Replies
View Related
Jan 23, 2009
Is it possible for a formula to calculate SLA's based on the time its logged on the spreadsheet.
For an example if a spreadsheet is opened and a date of a query logged in cell A1, this date would be 23/01/09. This would then be given an SLA date in cell B1 of 23/01/09. Unless this was inputted on the spreadsheet after 3pm then it would be given a SLA of 24/01/09.
Is there a formula which could do this as we have to manually check around 3pm and manually update all the SLA's.
Sorry it also needs to exclude weekends and bank holidays.
View 9 Replies
View Related
Jan 7, 2014
calculating the number of calls logged in a shift, based on a 3 shift system in a day. shift 1 from 08h00 to 16h00, shift 2 16h00 to 24h00, and shift 3 00h00 to 08h00. each shift receives a number of calls based on the time the call was submitted.
View 2 Replies
View Related
Feb 12, 2014
I've been tasked at work to make an excel file to do more than what I think I can figure out on my own. What I need done is this:
1. Every Monday, check excel file for data
2. If data exists, send email with said data
Here's my issues:
How do I get the workbook to open while logged off the computer? The file is stored on a share network drive, not locally. How do I get it to send an email without someone logged on to click "send"?
I tried using windows scheduler, but I don't have sufficient privileges to run as batch (IT restrictions).
View 2 Replies
View Related
Jun 6, 2008
I am trying to ask to the user to check if they logged out when they close the workbook but my code is not working...
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets("OD&D Log-in").Select
If Range("H5") = "reconcile" Then
a = MsgBox("Do you want to Log-Out?", _
vbYesNo)
If a = vbNo Then Cancel = True
If a = vbYes Then
Sheets("OD&D Log-in").Select
Else
Workbooks("Daily OSD Log (ver5).xls").Close SaveChanges = True
End Sub
View 9 Replies
View Related
Apr 24, 2009
I am having an issue with Excel creating a duplicate file when logged in as a user with restricted permissions on our network. If I modify a file while logged in as another user, excel will save the file but will also create a duplicate file with an eight character random name and no file extension. For example if user "Dave" opens a file called test.xls and saves it, in that same folder on the server a file named 296E9E20 will be created. Users are using Windows XP SP3 boxes and the server is running Win 2003. I am not sure why this only happens with Excel.
View 3 Replies
View Related
Jan 19, 2009
I have a column of names, and I want to be able to count all the instances of each name, as each instance represents a sale of a product.
Countif(Sales!B:B,"Dave") works, counting all the instances of Dave.
But if I have all the names in column A, and try to have column B give the results (from another WS), as in: =COUNTIF(Sales!B:B,'Best Customers'!A1), I get a "0" as the result. Yet XL help says countif can be used as =COUNTIF(A2:A5,A4). where A4 holds the value to search for.
While we are exploring this, is there a good way to look in a column, get every different instance of the names, and output them into another column?
View 9 Replies
View Related
Oct 1, 2008
I need a formula that will scan column A (Code)total the like items (also) add column B (Qty) if there is a number greater than 1. Then add the price ($) together and divide by the sum of A&B.
In other words find the average price for the total of each item..
A B C
Code Qty $
PH06003000 1 1504.8
PH06003000 1 1582.24
PH06003000 1 1606
PH06003000 1 1504.8
PH06003000 2 3009.6
PH06003000 1 1504.8
PH06003000 1 1504.8
PH06003000 1 1504.8
PH06024000 1 2499.2
PH06024000 1 2499.2
PH06024000 1 1896.07
PH06024000 2 3909.66
PH06024000 1 2240.7
PH06024000 1 2259.4
PH06024000 15 30030
PH06024070 1 2039.4
PH06024070 1 1958.66
PH06025670 1 2521.2
View 9 Replies
View Related
Jan 28, 2014
I am trying trying to calculate the amount of time students view videos. I understand I should use [h]:mm:ss but excel continues to convert entries such as 0:14:59 (0 hours, 14 minutes, 59 seconds) to 12:14:49 PM both in the cell and the function bar.
The problem gets complicated because I have entered the data with two different formats; some in h:mm and some in h:mm:ss'
1) Is there an easy way to sum the duration time so it accurately reflects total hours:minutes:seconds?
2) Do I need to reformat or re-enter data to make it work?
3) If so, is there a macro to do it?
This has been a bear, (40 students by 30 videos) all hand coded.
View 5 Replies
View Related
Oct 26, 2008
Date problem.
I need to find the duration of time based on 4 columns:
column A : Start date DD/MM/YYYY
Column B : Start time HH:MM:SS [24 hour clock]
column C : End Date DD/MM/YYYY
Column D : End time HH:MM:SS [24 hour clock]
Column E: The duration result in : in Days and Hours
I have several thousand rows and need to complete before tomorrow
View 9 Replies
View Related
Feb 16, 2010
I have the below Date & time in cell a1 and another date and time in cell a3
8/2/2010 08:45:00
8/2/2010 10:15:00
I need to be able to show duration (in hours) between the 2 times, in this instance its the same date, but this wont always be the case. To add a level of complexity in addition to the gross duration in hours, I will also need to know how long (in hours or mins) of the duration fits into "in hours" ( 9 -5 mon- fri) then the duration thats fits "out of hours" (after 5pm weekdays or all day Sat & Sun)
View 9 Replies
View Related
Dec 17, 2013
Formula that can calculate % of total for individual items. For example,
Item NoCategorySales% of total
1234Bed150
5678Bed100
1547mattress52
58658mattress188
12356bed12
8954mattress185
I need to find out each item % of total per their own category. For example item 1234 should equal 150/(Total Bed) to get % of total per category and item 1547 should equal 52/(Total of mattress)
View 2 Replies
View Related
Mar 13, 2009
I have a large spreadsheet with various data. On the first column I have a list of user ids, this is a unique id to each user. In each row there are data there are varies other data. I want to find a unique id and then add up the figures from week1, week2, week3 and week4.
So lets say I want to find user number 1 and the total for weeks 1, 2, 3 and 4, how would I do that using an excel formula? I have given an example below but I have simplified to spreadsheet.
IDWeek 1Week 2Week 3Week 4
139424236
255556044
334335434
461515350
529504694
618243830
View 2 Replies
View Related
Feb 28, 2012
Say I have a listing of cells
1,8,57,77,100, 104
I have a number I would like to find that is made up of a number of these cells. Lets say that number is 205, and as such the only possible values that could make that total are 1,100, and 104.
Is there a formula I can run that will allow me to find this number without manually figuring it out.
View 4 Replies
View Related
Nov 18, 2013
what im looking for is, i have two different rows i.e. col A and col C is the "type".
col B and col D contains "quantity".
i want in column E, listed all unique types in col A and col C and their respective total in front of the next column i.e. in col F.
col A.....col B.....col C.....Col D
150...... 6.........120..... 4
150...... 6........ 120..... 4
2.5....... 6
25 ........ 6........ 25 ....... 2
25 ........ 6 ........25 ....... 2
25....... 12....... 25....... 2
25 ........ 6 ........25....... 2
185 ....... 6 .......150...... 2
185 ....... 6....... 150 ...... 2
View 9 Replies
View Related
Feb 19, 2008
I have two workbooks, (Invoice.xls) and (Inventory.xls) both using sheet1. When I fill out an invoice, with lets say 10 items on sheet1 column B, I need a macro to find those items in workbook "Inventory" sheet1 column A. When the item is found, I need the qty I entered on the invoice workbook "Invoice" sheet1 column C (same row as the item number) to be subtracted from the current total for that item in workbook "Inventory" sheet1 column C. I would like to run the code from the workbook "Invoice" before I do a "Save As".
I have found other Vb code on this site that seems very close to what I need, but I just don't know enough to make the changes necessary.
View 5 Replies
View Related
Aug 2, 2014
I have been playing around with some data and can't seem to get it the way I want it. I have played around with Pivot tables and grouping but I can't seem to figure out how to accomplish what I need in Excel. To better explain I have attached some test data of what I am trying to accomplish.
View 14 Replies
View Related
Nov 18, 2008
I have a list of numbers and want to see if the sum of any of them exactly makes up a specific larger number. Any quick way to do in excel? Eg do any of the below together make the exact total of the number at the bottom.
242.91
265.71
95.96
113.26
228.16
48.59
64.62
70.59
88.88
146.51
228.99
67.99
40.22
71.51
85.28
654.15
View 2 Replies
View Related
Jun 10, 2013
I want to find the total number of times the number 1 appears in cells B2 to B33.
In each cell I have codes such as 4919409382a, 5021193035v and so on.
I have tried =COUNTIF(B2:B33,"1") but just get 0 returned.
View 3 Replies
View Related
Mar 14, 2007
I need to find the total number of rows down to the next blank cell (and then perform a function based on that number).
I'm using:
CountA(A1,xlDown)
Situation: I have a raw data import - each record is anywhere from 2 to 9 rows, and I need to move each row in that group into a column.
I would like to use something like:
totalRows = Application.WorksheetFunctions.CountA(Range("A1, xlDown"))
If totalRows = 4 Then
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.Cut
ActiveCell.Offset(-1, 1).Range("A1").Select
ActiveSheet.Paste
etc.
View 9 Replies
View Related
Sep 30, 2006
I guess this would work in a similar manner as Solver, but where Solver tweaks cell values to equal a given total, I've got a set of cells and I need to find the combination that equals an amount in another cell. Is there a way to do this?
View 7 Replies
View Related
Nov 9, 2008
I'm trying to create a work sheet with start and ending times with a 30 minute meal break, for the end of the week I would like to calculate those hours as a general number.
View 2 Replies
View Related
Aug 7, 2009
I have a worksheet where I calculate the duration it takes for an operation. the format of the worksheet is as folows:
The worksheet is composed of Start and Finish times in this format: 2009/06/02 5:32:19 , so for example,
- Row1 of the worksheet will have "Start" in column H1 and the start time in column B1
- Row 2 of the worksheet directly below has the "Finish" time, with the Finish time information in column B2
So with the help of excelforums I was able to implement a macro to extract the finish time cell found in row B2 and offset it to C1 and do a simple calculation to get the duration in minutes and display it in column D of the same row as "Start".
View 12 Replies
View Related
Oct 9, 2012
I'd like to write a VBA script which writes all data of my mp3s in a spreadsheet. I can read all data like the artist, songname, album, year, this works fine. However I'm not able to get the duration of the mp3 files. Any sample script which reads the duration of the mp3 files?
View 2 Replies
View Related
Jan 12, 2008
I have following data, data_in and date_out. I need to auto cal these 2 variable different and give the output as duration in month.
x_INV EF1date_lndate_out205/10/195005/10/1950325/10/195025/10/1950415/11/195015/11/1950508/01/195029/10/1950618/10/195018/10/1950717/10/195017/10/1950817/10/195017/10/1950915/10/195020/12/19501013/12/195013/12/1950 Excel tables to the web >> Excel Jeanie HTML 4
And give the result in colume X as following :-
x_INV X1stk_dur20304051060708092 Excel tables to the web >> Excel Jeanie HTML 4
View 9 Replies
View Related
Feb 2, 2009
I have 10 columns (1 through 10) called TASKS and 2 rows for each task
Row 1, has a 'start date' in the form of 1/1/2010
Row 2, is duration
the duration of each task may or may not overlap with other durations of other tasks.
how can i find out the total duration of ALL my tasks.....without any overlaping.
any formula that can calculate this? ( i need one number at the end!)
View 9 Replies
View Related
Jul 21, 2009
I've recently been experiencing some strange phenomena in relation to public variables. It seems that if I run separate routines in quick enough succession (e.g. press a button twice within a couple of seconds), the memory of the public variable "hangs over" into the second routine.
The routines, however, are completely separate events. And I'm not using userforms or anything like that in order to keep VBA running in the background. In which case it seems that Public variables don't always get set to nothing with the end of the final sub in a routine. Has anyone else experienced anything like this? I was under the impression only Static variables could do this.
View 9 Replies
View Related
Aug 28, 2006
Is there a format for duration of time. The attached spread sheet has column B "Duration". This is the actual time on which I need to do calculation. On "C2" I have the formula "=IF(B2>10,400,B2*40)". The formula is " if value in B2 is more than 10 hours then the value in C2 should be $400 , else C2= B2(duration time) multiplied by 40.
View 5 Replies
View Related
