downtime

HiAll Hoping you could help me achieve this layout I have a pivot table that stores the location in thr rows Either Office Home I have downtime Printing in values and Downtime standard in values too The problem im having is that Downtime Standard appears in both WFH and office I want to...

I have a spreadsheet where workers can calculate downtime simply by entering the start of the downtime and the end of the downtime. This works great until it occurs before midnight and then ends after midnight. How should the formula go to account for the day? I have a start shift and end shift...

I have an excel sheet with the following layout: My goal is to find each occurrence of a machine number that has a downtime equal to or greater than 4 hours and put that info Plus the reason into a separate table. I want to search by machine number find downtime =>4 and return each occurrence of...

Hello all. I have a spreadsheet that automatically calculates downtime based off of military time entered into two other columns on a corresponding tab. I use a SUMIF function below to come up with a total downtime for each server in all columns "E", and add the downtime together from all...

I am trying to compute the downtime and have a formula that subtracts the on task time, transit and wait time from 24 hours. However if the sum of the calculation equals 24 hours then I get #####s in the cell; if it equals 00:00:01 then it will display correctly ie 00:00. Is there a way of...

Hi all, thank you for looking in to this. I have crated a formula to count downtime min from ('Master Data'!X column) when downtime category from B29 equal to range 'Master Data'!W column (see below). =SUMIF('Master Data'!$X$3:$X$4519,"*"&'Data (by date)'!B29&"*",'Master Data'!$W$3:$W$4519)...

I have been unable to get anything other than errors up to this point on this problem. All numbers are in hours I have a set of data (3 columns by about 828 rows) that has the queue start time(D3:D830), work start time(E3:E830), and work completion time(F3:F830). These are the three columns the...

HI all, I'm having an issue returning multiple results for a vlookup I'm using to tell me all instances that have occurred for a certain time period. What I have is a certain point in time in one sheet that I need to know all the downtime events that were occurring at that point in time. My...

New to the board and kind of a noob with Excel in general. I am trying to track server uptime. I've created a spreadsheet that we are going to use to track times when the server was down. So in A1 I've got "Outage Start," B1 "Outage End" and C1 "Total Interruption" in minutes. I'm recording...