time

Hi All, Hoping to get some help, I'm using the distance and time calculator, that is supplied on the chandoo website, I have my API for bing and everything is working 100% when I save things locally, I have it integrated into a excel project calculator for projects. Which basically calculates...

I have data like the image below. I am trying to select a range from Cell B7 to Cell B908, Do Something, Select range B909 to B1807, Do Something, and continue this loop until I get to the last row of data. The cycle runs about 45sec each time, but there are always multiple instances of the time...

Please see attached image. In the highlighted green area, I need a calculation that would calculate time rounded up to the nearest 0.25. I am having a contractor work for me, so all time is only like this: 12 PM 12:15 PM 12:30 PM 12:45 PM 1:00 PM So I am not doing hours like 2:34 PM or 5:49...

I Have a item " spoon " Price is €0.07 per day One customer who has ordered 50 spoons on 1.11.20 ( and still has not returned them). On the 7.11.20 he orders another 40 spoons. On the 14.11.20 another 20. On the 21.11.20 he returned 30 spoons ( I would charge him 21 days at € 0.07) On the...

How can I complete this timesheet? I need Total Time worked (End Time less Start Time less Break) and Total $ Due. I've tried it with the Break as minutes or hours or x24, formatted as h:mm or 0.00. I just can't get there. Can you help? Date Start Time End Time Break (Minutes) Break (Hour)...

Hello, I have two spreadsheet, both on the same workbook, which I have to update links to every day before our morning meeting. I've added an "Edit Links" shortcut to my "Quick Access Toolbar" so I can easily update the links but sometimes I become busy and forget to update them which causes...

Hello Excel Gurus! How can I format an Excel TimeDate from a double to mm/dd/yyyy hh:mm:ss.000 Thank you! Please call this sub to demonstrate my question: Public Sub TimeWithMS() Dim Timestamp As Variant Timestamp = Evaluate("Now()") Debug.Print Tab(0); "Timestamp:"; Tab(15); Timestamp...

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...