i am trying to lunch screensaver using this code, which worked with Excel 2003, but not with Excel 2007 which i am using at the moment. when excution comes 2 :
VBA.Shell "C:WINDOWSsystem32ss3dfo.scr /S", vbMaximizedFocus
it tells file not found. any idea how 2 make it work in Excel 2007 ?
Sub RunScreenSaverProgram()
'*To show the screen saver
VBA.Shell "C:WINDOWSsystem32ss3dfo.scr /S", vbMaximizedFocus
End Sub
I am working with the following time sheet/card (attached) and it works great when the person goes to lunch, but when they skip lunch I cant get it to compute correctly. I set the formula back to original state because it was just getting more and more confusing. Additionally I tried to adjust it for working overtime (more than 8 hours in a day) and double time (more than 12 hours in a day and kept getting errors or incorrect results).
View 9 Replies View RelatedBasically I have a timesheet as follows:
Basic Hours Worked
Overtime Hours Worked
Day
Time In
Time Out
Hours Worked
Time Decimal
Lunch Hour
Number of hours
Mon
8:56:00 AM
4:50:00 PM
07:54
7.90
[Code] .......
To determine the hours worked from the times input I am using the following formula:=
HOUR(D65)+MINUTE(D65)/60
These formulas seem to be working fine but what I am stuck on is deducting and adding lunch hours and overtime hours.
The first problem I have is for example if an employee were to type the figure 1 in the Lunch Hour column for each day lunch is taken I would like it to be subtracted from the bottom total.
Also if any overtime were input on any day I would need it added to the totals.
I work at a call center and I have to report absent time for my agents.
I am working on a template that was previously saved, however, the absent hours do not account for when the person has not been to lunch yet. This is usually done as a manual update.
There are three main situations that I need my formula to account for:
1) Person that has been absent all day
2) Person that has been absent part of the day (after lunch)
3) Person htat has been absent only a few hours (before lunch)
Lunches are 30 minutes long
Whenever a person is absent or late, we put their time in two columns called ABS in and ABS out. It basically marks the start and end of their absent time.
ABS IN is when their schedule would have startedABS OUT is when they arrived if they were late, or their out time if they were absent all day.
Here is what my spreadsheet would kind of look like... I need to know how many absent hours there were to calculate the actual worked hours.
I cannot simply deduct abs out minus ABS in because then I am not factoring in the lunch times.
This is how my spreadsheet roughly looks like:
Agent
SCH TIME IN
Lunch
SCH TIME OUT
ABS TIME IN
ABS TIME OUT
Total Sch Hrs
ABS Hours
Actual Worked Hrs
Person absent all day
8:00
12:00
16:30
8:00
16:30
8.00
Arrived late (before lunch)
8:00
12:00
16:30
8:00
10:00
8.00
Arrived late (after lunch)
8:00
12:00
16:30
8:00
13:00
8.00
On Time
8:00
12:00
16:30
8.00
I'm just looking to prevent users from using the print screen or the alt print screen buttons on the keyboard. I have this script that works if I use "39" (Right Arrow)but wont work if I use "42" (Print Screen Button).
View 5 Replies View RelatedI am using excel 2010 and I am trying to find a formula whats going to give me added break with a set time but anything over a set time doesn't. I want it over 10:58:00 and under 11:32:00. I've got the numbers and tried with a formula but all whats happening is that all the data is adding 30mins break to the end time.
The sheet is using live times and data so the start times vary as do the due time.
I am trying to get the start time and finish time for breaks.
I have 4 columns Name, status, start, finish. In the name column there are multiple names, under status there 6 different status's. and under the time columns there are in and out times dependant on status. I am trying to us index match match. I have tried vlookup and hlookup as a nested function. I keep getting errors.
NameStatus MessageStart TimeFinish Time
Cameron WilliamsTech All & Billing12:31:4812:31:52
=index(starttime,match(name,namefield(match,"on lunch",starttime)))
[Code]......
I am creating a worksheet where employees schedule work throughout the day
eg task 1 will be start time 9am, finish time 11am. The result is 2 hours to do the task.
The problem i'm having is that I need to do a calculation that if a task includes lunch then the result takes an hour away from the task time.
eg task 2 will be start time 12pm, finish time 3pm, excel displays 3 hours, i need it to say 2 hours because 1-2pm is contractual lunch.
I can't just do a day formula that says minus 1 from total as this is task orientated and will vary depending on start and finish times of each task.
I need to Find Out the Number of people staffed per interval I used to use a formula like this in order to calculate this it takes in to account Lunches.
=SUM(IF(A8>=$B$2:$B$6,IF(A8=$E$2:$E$6,IF(A8
If a person does a full day I want the formula to calculate how many hours minus 30 mins for lunch i.e. 7:30 - 4:00 = 8 hours. I have done this and it works fine, the problem comes when a person does a half day i.e. 7:30 - 11:30, this will read 4.5 hours. If this is the case I don't want the 30mins deducted so it should be 4.0 hours worked.
I have high lighted a column in the work sheet (yellow) whereby the user puts an 'x' in the appropriate cell if they are working a half day.
The probem is I cannot incorperate the two formulas in one cell (the Actual hours cell) I have the one formula in the actual hours cell and the other bolted on the end thus giving two different readings.
I need also to calculate difference between dates(dd-mm-aaaa hh:mm) in workhours ( hh:mm):
The work period is 9-18 with lunch interval 13-14 The startdate and end date could be out of the work hours and i can't include the extra hours. I can have several days (workdays) at the difference, but i should maintain the format hh:mm.
Ex1:
Startdate 05-03-2013 18:34 ( date to calculation should be 05-03-2013 18:00)
end date 06-03-2013 10:30
Time Difference 1:30 ( from 9 to 10:30 of 06-03-2013 )
will be equal to:
Startdate 06-03-2013 8:34 ( date to calculation sould be 06-03-2013 9:00 )
end date 06-03-2013 10:30
Time Difference 1:30 ( from 9 to 10:30 of 06-03-2013 )
Ex2:
Startdate 06-03-2013 12:01
End date 06-03-2013 14:28
Time Difference 01:29
I would like a solution for the automatic calculation of the end date and end time for project tasks. I have already spent hours on the issue, thanks for any help on this.
The parameters are:
A1 = Start time 08:00
B1 = End Time 17:00
A2 = break lunch 12:00
B2 = back from lunch 13:00
Task parameters
A5 = start date 01/03/10 (entered manually)
B5 = start time 10:00 (entered manually)
C5 = duration 02:00 (hrs entered manually)
D5 = "end date" >>> (to be calculated exluding breaks and holidays)
E5 = "end time" >>> (to be calculated exluding breaks and holidays)
the next line should be filled in automaitically according to the hours needed and the previous end date & time
A6 = "start date" >>> (after line 5: to be calculated exluding breaks and holidays)
B6 = "start time" (after line 5: to be calculated exluding breaks and holidays)
C6 = duration 14:00 (entered manually)
D6 = "end date" >>> (to be calculated exluding breaks and holidays)
E6 = "end time" >>> (to be calculated exluding breaks and holidays)
and so on for every new line down.
Lunch is not paid. Holiday and vacation hours get calculated at the regular pay rate. Overtime is anything in excess of 8 hours per day and/or in excess of 40 hours per week and/or over 5 working days per week. Saturdays for most the employees will be overtime because it will be their 6th workday of the week; but it will be regular time for one employee as it will only be his 5th workday of the week.
For accounting and payroll purposes, we need the totals to display in both hour and decimal format.
So far, I have Lunch, Regular and Overtime hours figured out, but I still need to work with Saturday, Vacation and Holiday hours. Also, currently, the time in and out has to be typed in with the colon and AM or PM. Is there another way to input the info without having to type in those items? I'm trying to make it as user friendly as possible.
I'm attempting to make a simple time sheet for a handful of employees. I'd like to enter the clock in time and clock out time for each day. The end cell should be the running total for the week. The tricky part for me is having the formula subtract an hour for each day that is over 5 hours.
View 3 Replies View RelatedI am making a time sheet for work. It should be very simple but cant get it to work. I want time in, time out, lunch column, and Total. I don't want a lunch in and a lunch out though just a section where I can put my time in :30 minuets :45 or what ever. I also want it to work. on a 12 hour clock AM/PM .
Here are my column's
B2 Is Time In
C2 is Time out
D2 is Lunch time ( decimal ? )
E2 is the TOTAL with lunch deducted.
I did the restart our company required and when Excel reopened it was on my laptop rather than the big screen. I run 2 screens. Excel 2003 is now so far up on the laptop screen, I cannot move it. I can barely see File, Edit, View, etc. How can I drag Excel down so I can resize it?
View 4 Replies View Relatedwhat size monitor do you use?
I'm thinking about upgrading my 17" to a 23" monitor so I can see more cells without zooming
Anyone currently use a 23" for Excel?
I would like to end a macro with a specific cell (e.g. E50) in the first cell in the upper left hand corner of the screen. How might I accomplish this?
View 3 Replies View RelatedI cant get my screen to go all the way to the top of the page! & there is a 2 inch or so area at the bottom of the worksheet as well. I need to get my display back to normal!
View 4 Replies View Relatedmacro minimizes excel takes a print screen of the application behind excel then pastes it in a word document then maximizes excel screen again
View 9 Replies View RelatedI have never created a splash screen and would like to do so now, I am in the VB editor, i have inserted a userform, i would like to insert my company logo on to the userform, how do i do this?
View 9 Replies View RelatedIs there a way to disable updating to the screen but have a message displayed to the user while a macro is running? Something like a userform displayed on the screen or a message in the status bar. I vaguley remember you could "print" message to the status bar in LotusScript, wondering if there is something similar in Excel.
Application.ScreenUpdating = False
"the macro is running, hang tight"
...macro code in here...
Application.ScreenUpdating = True
I have a large workbook with about 20 worksheets that I have used for several years without problems. Recently, I have been getting strange behavior when the screen refreshes. The biggest problem is that I get images of other worksheets covering my current worksheet when I change a cell. I can make them go away by scrolling or flipping between another worksheet and back. I have tried using manual recalc and this has helped somewhat but I can still get the images sometimes. The workbook contains VBA that performs various tasks on every worksheet (unlock, update pivots...) but these have been in there forever. There is also one piece of code that performs advanced filtering. I can only think there was something changed with a security patch, but I wanted to know if anyone else has had this issue and might be able to provide some advice on how to prevent it.
View 9 Replies View Relatedstretch" the userform to fit the height and width fo the screen. I dont want to simply change the height and width of the userform, i want the controls within the userform to stretch with the userform so that it looks the same, just fullscreen. this is what ive found by googling:
VB:
With Application
.WindowState = xlMaximized
Zoom = Int(.Width / Me.Width * 100)
Width = .Width
Height = .Height
End With
however, this just stretches it to match the width of my screen, but doestn consider the height, so that if i have a widescreen vs a square screen it will cut off the bottom of my userform. It would be great if there was a zoom type featur that zooms the vertical and horizontal dimensions seperately... more like a stretch than a zoom.
I want to save an image of my worksheet, after I have right clicked, to be used in a power point presentation. How do I do that?
View 2 Replies View RelatedBeen trying to figure out if there's a way to keep sub-headers visible at the top of the screen.
Basically I want the main headers locked at the top (via freeze panes), but then I also want certain rows, which would be sub-headings, to stick to the top of the screen until the next sub-header row gets to the top of the screen, at which point that row would replace the other one at the top.
The best example I can provide of the behavior I'm looking for is on the iPhone Contacts list. When you scroll through the contacts you see the listings, but as you scroll into each new letter that particular letter's sub-heading stays stuck at the top of the screen until you scroll down to the next letter.
So example would be:
Quantity Item Price (this would be the header row locked to the top via freeze panes)
PRODUCE
1 Apple $1
6 Orange $1
8 Pear $2
DAIRY
1 Cheese $5
7 Milk $2
So if you scrolled the above list down PRODUCE would stay at the top even while the Apple, Orange, and Pear lines scrolled off the screen, then it would get replaced with DAIRY when DAIRY reached the top of the screen.
I have 2 workbooks open. In the workbook that I am working in I run a macro from a userform to copy a worksheet from the other workbook that is idle in the back ground. I also display another user form that says "please wait" while the macro is running.
The problem I have is even though screen updating is set to false the screen switches over to the other workbook while it is copying the desired sheet and switches back to the workbook I am copying to after the macro completes. Also the "Please Wait" userform disappears while the other workbook is displayed and reappears when the initial workbook returns.
Below is my code which works without issue but perhaps there's a better way to copy between workbooks that would prevent the screen changes?
[Code] ........
How to get a Splash to show on WB open without seeing the Excel worksheets briefly flash before the splash loads.
(Note you will still see the Excel loading window prior to the splash appearing but I don't worry about that).
I need to improve this project i've created. right now this project is an Exam for our agents. You can try it first if you want. I've attached the file below.
I need putting a timer that will compute the seconds or minutes it took the agent to finish the exam. timer should start after they click "Take the ETP" button. And finally, creating a screen / a pop-up that will show the ff example.
[I]EXAMPLE:[/I]
Name of Examinee
Answer:
1. A = Correct
2. B = Incorrect
3. A = Correct
4. C = Correct
5. D = Incorrect
Testv2.xlsm
I am quite new to the excel vba. I am trying to create a login screen
So whenever i open my excel sheet, the first thing should happen is that there should be a login screen and ot should ask for password and id. Once you provide the login id and password, you would proceed to the next screen.