lunch

Hello I want to get hours worked. I am using the below to formulas. The first one is just a straight Start Time - End Time but if that is over 30 minutes I want to use the second formula to subtract 30 minutes for Lunch. They both work but how do I put this into an iif statement. I cannot...

Hello All, How can I show the value of the last cell in column H as soon as its dependent cells (column C is Start Time, column D is when one clocks out for lunch, column E is when they came back from lunch, and column F is their total lunch time taken)? column B is the date column C is Start...

Hello, I am new on VBA and all I know is been from reading this website and again I hit the wall... :confused::confused: I hope that you can help me on this one: We have a database that collects the time that the employee is actually working, so far I have a userform that has 4 options where the...

Hopefully I will explain this well enough to understand outside my brain. I have 2 columns of shift times (Shift Start and Shift End) all on the even rows. Under their shifts is the row that has their Lunch break start/end times. I need to get an interval count of the number of people staffed...

Hello, We import a report from a website and several of the key information get put into one cell which is very annoying. The problem is the number of characters differs in each cell. With the example below, what formula can I use to get the ":No of Delegates:" values in column B, which would...

Hi - I just wondered if there is a way of shortening this code down (loop it?)? I want to apply this code to rows 4:43 but excluding rows 8,9,19,20,27,28,40,41 If Range("AM4").Value = "E" Then Range("P4:S4").Value = "Lunch" Range("T4:W4").Value = ""...

ok working on a time sheet i wanted teh time sheet to take the emp start time from the top and use it for the first entry when you enter a time it took it adds to the start time that duration of entry and makes a end time then it checks then next lien and if therer is a duration it adds that...

I have made a sheet with a dropdown list of my employees names, as well as another sheet with the names, and columns with dates, and in, lunch out, lunch in and out columns within the date ones, I am trying to figure out how to have it so when they select their name in the dropdown box and click...

Hi Guys! I'm having a little difficulty with this problem. I have 3 different lunch times depending upon hours of work. They are: 5 hrs, no lunch; 5.5-6.5 hrs, 30 minute lunch; 7+ hrs, 1 hr lunch. So I'm trying to be able to merely punch in my start:end times and have the formula calculate...

I have a worksheet set up as a schedule for 8 people, for the entire month. Z6 & Y6 have the start time & end time of this persons shift on a specific date (if they are not working it's left blank). If there are work times in the cells, I want it to subtract the end time from the start time...

Hello ~ Haven't experienced this before... Below is basic Advanced Filter code using 2 criteria: "does not equal Lunch" and "does not equal Holiday" When I run this code it won't filter for either of the two criteria With Sheets("Sheet1") .Range("P2") = "<>" & "Lunch" .Range("P3")...

My spreadsheet is an on-site catering database. In this spreadsheet I have the date of the meeting, the vendor/vendors that are used for the particular meeting, these meeting maybe a breakfast, lunch, or dinner meeting and there may be multiple vendors per meeting. For example I have 2 columns...

My cells are: Time In Out To Lunch In From Lunch Time Out For Military format I am using 00\;00 Helpppppppppppppppp

hello, I am trying to calculate the Ot hours once the Regular Hours have reached 40. If you could help with this that would be amazing!! we work shift work so our hours are from 7-3 3-11 11-7 so the time must be able to calculate into another day. we have figured out a few of the formulas, we...

I'm not sure if this is possible, I've tried a few different things but the formula is too complex for my knowledge. Basically, I would like to look at my employees' hours worked for the week, the number of days they have left to work that week, and determine what their clock out time should be...

Hi wondering how can I get the total expense of Breakfas, Lunch and Dinner per day. Example of table below: <TABLE style="WIDTH: 312pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=415><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 52pt...