time analysis

The formula I am using is not calculating correctly. What am I doing wrong? =IF(C5=0,"",IF(C5>0,SUM(C5-20),IF(A5="*Nov*",A5="*Dec*",A5="*Jan*",A5="*Feb*",SUM(C5-98)))) What I am looking for is, if cell C5=0 then leave blank, if cell C5>0 then subtract 20 from cell C5, and if cell A5 contains...

Can anyone assist with figuring out a way to write out this function to where it takes both hour and minutes into consideration when comparing the NOW time? Details: This is the formula I have under John Smith 1 row...

Hi, I need to calculate the rest time between the end of a shift and the begining of the next one. What formula would I need to use to calculate the elapsed amount of hours/mins between C2 and B3?

Hello, Is there a formula to use in Power Query for (If time is between 7PM and 7AM then After hours, if not then Business hours?

Hi, I have a lot of remote camera data, and I would like to calculate the working hours of each camera in each season. I divide a year into two seasons: the breeding season (Apr - Aug), and the non-breeding season (Sep - Mar). Column J (Working hours) shows the total working hours, which are...

I am trying to create a measure that will show how many members our group has gained or lost since our last month. The data source is a spreadsheet exported from our membership software once a month, with rows for member ID, member status, and a couple of other columns. I have transformed that...

Hi, I am trying to figure out how to find the difference between two task times as long as their ID number is the same. This is for different shifts/days so when their shifts ends at 3AM and starts back at 4PM the next day I don't want to take the 12 hour time difference - I want it to say 0. I...

Hello !! I’m trying to make a similar graph to the one attached . Is there anyway to do this ? I have a start and end time and criteria (instead of weekday I have area )

I'm struggling to come up with a formula that will look at the start time and subtract it from the end time (if the dates are the same) and if the difference is 1 minute or 30 minutes, color it green. I've tried googling this and have not come up with anything that works at all. I'm hoping that...

I need to convert these cells that contain elapsed time in the format shown, to total minutes. The data in the cell is texts and numbers – there is a space on both sides of each number. The formula is a Value function with a nested Find – it’s not working for me, however...

Hey all! I'm trying to pull out data from an extract that contains employees with their start and finish times worked and split the hours they've worked across 1,2 or 3 different shift times. My problem is the extract doesn't give me a date, just an AM/PM time for both start & finish so there...

I have hit a wall figuring out how to best get this done... Based on this: 5. Employees Normal Work Hours 8:00:00 AM to 4:45:00 PM Date Start Stop Total During Working Hours Total Outside Working Hours 12/1/19 6:30:00 PM 9:30:00 PM NEED THIS VALUE NEED...

hello, I have data that present at hh:mm:ss eg 00:01:52 but when I try to average I get the DIV error and when I try to sum it comes out as 00:00:00 I have tried the different formatting but nothing changes.

Hi all, I am new to this so bare with me. Below is the current solution to my predicament, done manually. I would like to automate the distribution column. For this, the numerator is the TVU column, and the denominator is determined via the COUNTIF() function. The issue is that I cannot get...

Hi, i'm a newbie in need of urgent help. I have a data set that records meeting occurrences. The start time and end time of the meeting are in a cell each (Rows I and J in the attached image). I am trying to count meeting occurrences looking at half hour intervals. For example if a meeting...

Good Morning I have an issue. I've been trying to create a formula to count the number of instances a particular time range appears in a column on a spreadsheet. Column C contains manually entered times followed by AM or PM. One problem I've run into that may or may not be effecting the...

Hello I have a question I'm having problems finding a solution for. I have a time sheet which someone would complete as 07:00 in, 12:00 out for lunch, 13:00 Back from Lunch, 17:00 finish. What Im trying to do is to break down what the person has put in so it shows at what points during the day...

Hello, In the following example below I am trying to use a SUMIFS/MAX formula to get the total sum of a event minus the allowed amount of time for a event. When i try to use the formula below i get a sum of 0:00:00 instead of the actual value. Should i use a different formula completely or does...

Hi, I have two columns, one with a date and time (column A) and one with a status (column B). I want a third column(Column C) to say if the date and time in column A is less than today's date and the status in column B is not equal to 'COMPLETED' then move the date to today's date at 07:00:00...

<tbody> Name Org Day Start End Minutes Incorrect Person 1 A Monday 5:05 pm 6:00 pm 0:55 0:25 Person 2 B Tuesday 5:05 pm 5:15 pm 0:10 0:10 Person 3 C Saturday 6:15 am 2:50 pm 8:35 0:00 </tbody> Hello all, Hoping someone can provide some assistance with...