hours

Hi my fellow excel warriors, I am looking for an excel template to track holidays. I have found trumpexcel. com/excel-leave-tracker which looks pretty good but I need it in hours and not days. Can anyone help? Many Thanks

Hi, Could somene tell me if there is a way to sort a list of jobs that are required to be done over a monthly period (per day) I have a list of tools and how many hours they have been used for, i'd like to be able to plan how many jobs i can do per day ( 3,4,5,6) is there a formula i can use...

Hi All Sorry for being a noob but I'm trying to fid a formula that will allocate the time spent on a job EDIT: More details in post#4

Hi All I've learned quite a lot about working with dates but never worked with times. I have to do some tidal calculations and need to calculate a time 3 hours and 5 mins before high water (I literally have to deduct 3 hours and 5 mins from the high water time which I have in column B) the...

Hi, What formula would i use in D2 to get the correct days, hours and minutes duration between cells A2 and A3? A2 01/09/2019 19:07:30 PM D2 Formula to state 1 Day 11 Hours and 18 Minutes A3 02/09/2019 16:10:50 PM Thanks.

I am doing timesheets and the following is the layout E F G H I J Start Break Finish Normal Hours Time &...

I think I need to use an IF formula but can’t work it out. I have F4+E4 to give me the G4. So i have a few different hours so I need the formula so that if G4 is equal to or greater then 8 then the remainder hours calculate to multiply by 1.5 Can anyone help please?

Could someone please help me to add multiple functions in a search string? =IF(MID(B18,2,8)="01330701","11-13 hours","") is giving me the desired result for that one formula. I need to check B18 for 5 different number sequences which would return the same, "11-13 hours" result if met. For...

Hi, Can someone please come up with a formula? If I clock in at 8 am (cell L5) and need to work 9 hours (cell O2) what time do I clock out? There is a lunch break: L2 (12 pm) L3 (1 pm) Also this may be a job that carries over from the previous day as in the 18.0 hour JOB TIME can the...

I'm trying to calculate elapsed time in hours from a start date/time to an end date/time. Work hours are M-F, 6AM - 6PM. Below is the formula I'm using. =(NETWORKDAYS(B3,C3)-1)*("18:00"-"6:00")+MOD(C3,1)-MOD(B3,1) The problem I'm having is if the start day is after business hours or on...

Hi... I'd like to ask if someone can help me to find the correct formula. I have an overtime tracking template for 31 days, the threshold total hours for the month is 303 for 30 days which is 10.1 per day, if an employee worked from 1-31, the threshold should retain 303, but if an employee...

I'm working on a sheet that has multiple tables of data. One tracks budget and one tracks labor hours. In the labor Hours table, I created a toggle button that will hide rows containing employees who have contributed zero hours towards a project. It was working GREAT, but I had to make some...

Hi, Looking help in constructing a formula to help me interrogate a large data area which if 2 criteria or met then sum the associated hours worked. Basically I want a summary report that gives me the total hours worked by a particular grade for each month as we go through the year. Below is...

how i create counter that count down to 9/5/19. I not sure how do that? i want day hours minutes and sec Thanks you Thomas

Hi All, I have a sheet where it records a time when one of our trucks goes into a dealer. It also records the time the trucks leaves the dealer. I would like to workout how long the vehicle has been stood in the dealer. That is easy to do, but in order to be accurate, I would like the...

I'm summing total hours worked in cell J5, formatted as [h]:mm, to =sum(c5:I5) and getting 48:44. In cell K5. also formatted as [h]:mm, using formula =IF(J5>=40,40,J5) , I'm seeing 48:44 when I expect to see 40:00. In the next column, L5, formatted as [h]:mm using formula =(J5-K5), I would...

Hey everyone, I have a spreadsheet that lists my employees' work hours, including vacation, sick, etc. and keeps track of the balances and so on. I'm having difficulty trying to set up using a range of dates as the criteria for showing me information that could span a different range of...

Hello, I have an excel that contains total month wise time for each employee in columns. Total amount for each employee needs to be as calculated based on a slab. The slab is For 0-20 Hours: $8200 + $50 Per Hour For 21-40 Hours: $9200 + $60 Per Hour Now if a person has worked 38:55 Hours in...

hello all i have a few formulas running and the breakdown is below. I have a page which is called PTO Hour Settings" which the sheet "Employees" references. A manager is to input what information applies to his account in the PTO hour setting page so this formula needs to be universal. The...

Dear Members, My source data contains Days Column and Hours Column (Clocking In & Clocking Out Columns as well). My Pivot Table requirement is to have Total Hours Worked calculated and total days worked by customer. Can any one of sort it out for me? Regards,