time

I am trying to get a sum of time spent on the phone for agents. The format the duration is in is hh:mm:ss when I format the column and do =C2+C3 I get the correct output. When I do =SUM(C2:C55) the sum is 00:00:00. I've tried a few different ways to format and calculate the sum without luck...

Hello, i got a list of tickets with the dedicated time for each, i want to convert it in excel so i can sum the time consumed per week, but the time comsumption needs to be converted i wanted to make with if functions but maybe there is a more easier way, i identified 3 variants: -1h -1h 30m...

Hi everyone! I hope you all have a pleasant day. I do not know if this is possible in Excel, but I would like to ask. We have a KPI for report submission deadline. The rule is, maximum time for submission is at 00.00 in the same day of working day. This would score a 100%. After exceeding that...

Hey guys, I have a issue I have been trying to figure out all day. We have a KPI for a late early arrivals and our KPI if the departure is after 8 minutes of planned time or 12 minutes earlier, it qualifies as "on time". If its more than 12 minutes early it qualifies as "early" and if it is...

Hi there, I'm new to VBA and Excel. I'm trying to write formula or VBA code to be able to get EXCEL to automatically enter WORK SHIFT based on time when data was selected from dropdown list. I have created dropdown list but now I want EXCEL to enter WORK SHIFT automatically when I select any...

Hello everyone! I need your help in creating a time-and-motion using Excel VBA. Basically, I have a small UserForm which should contain a "Start", "Done" and "Restart" button. Start = start timer from 00:00:00 Done = End time from 00:00:00 Restart = reset time to 00:00:00 Other than this...

Hi, I've been trying to figure this out but haven't found a solution yet. What I want as an example is 0.00:04:53 What I'm getting when the table loads from power 0.003391204 The code section looks like #"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns2",{{"* FIRST...

So I have a spreadsheet to keep track of my time at work. It goes In - Out, In - Out, Total (time I clock-in in the morning then out at lunch then back in after lunch and out for the day). My total time formula for the day is represented as =SUM(B1-A1)+(D1-C1). My cell format is [h]:mm and so...

1.I want to find out if an event with start time and end time falls "inside" or "Outside" working shifts for associates. 2.Segregate and calculate the production duration that falls within shift hours or outside shift hours. (The Shift timings are 5pm to 2am which would be the next day so that...

Hello. I have a workbook I created to track break times at my work. I have a column of times in a workbook in the custom format [h]:mm:ss. Example 0:06:00 for six minutes. This column tells us how long the person went over the required break time. I would like to, in another column display this...

Does anyone have a solution to formatting mm:ss without the AM/PM after it. I'm creating a spreadsheet where I need to put time as an input, say for a race where something like 10:30 would be 10 minutes and 30 seconds. There are then some calculations done on the time which says if time is below...

Hi Guys, I am currently trying to put a sheet together that will automatically spread cost over time using multiple date sets. I have the formula working for one set of dates however some items need to be spread across more than one activity i.e. up to 4 sets of dates and i was wondering if...

I have a Cumulative Time field that formats as [h]:mm:ss that aggregates time in hours. I am needing to extract the time portion to convert it to a Text or String value. For example, a cumulative time total of 95:31:00 shows as "1/3/1900 11:31:00 PM" in the formula bar which is not what i want...

Hi I have received a spreadsheet from a colleague which has the time showing as 1:30pm and so on. The cells are formatted as General and no matter what format I try, I have not been able to convert the cells to show 13:30 etc. I even tried =TEXT(B2,"HH:MM") to remove the am and pm, but this also...

I have 4 columns, i want the first two to return the earliest and latest times from two other columns that have date and time (separately). I need a formula that will look at the data based on the date criteria and return the earliest time for that date and another formula to return the latest...

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 There, I have been working on a multilocation (6) weekly scheduling board for 19 employees with some of them having different attributes (notary/supervisor). I would like to make sure the same employee doesn't get schedule at two location for the same time, but sometimes, employees have two...

Hey guys. I am doing my first Power Query project using and have successfully transformed data are I wanted that I could not do in PowerPivot. However I need to convert the hours worked by each employees into Number so that I can take that number and use it in the payroll software to calculate...

Hello, I’m wondering if there is a way to change times, such as 158.30, to show the amount of days it adds up to if the days are 7.5 hours long? Thank you

I have date and time columns (start date/start time and end date/end time) that I am manually concatenating (typing) so that I can calculate a duration. I would like to be able to have a formula do this for me, but a standard concatenate doesn't work. How can I achieve this? START DATE START...