time

Hi everyone, I'm trying to count the amount of times 2 different cells have the same date and also the times in a 3rd cell need to match and the 4th cell need to be before/after a certain time. In my formula I've only managed to put in the times, so if the date is incorrect it will be counted...

I want help in getting time value of DateTime from column A as per manual typed time in column C Why there is a difference? ABCDEF1DataExtracted TimeManual TimeTestFormat22:00:00 AM2:00:00 AM2:00:00 AMFALSETime32:00:00 AM0.0833333330.083333333FALSEGeneral (Pasted as...

Hi guys, I really need help to set up a logical solution to this. In 'Value' column I want to have a value based on time interval. If a time interval in a cell in Sheet 1 falls inside a time interval in Sheet 2 then take the values shown in Sheet 2, otherwise 40. See image. THANKS FOR HELPING

I'm most likely asking for the impossible, but is it possible to take a column of numbers showing time in a mm ss format and add them all up into an hh mm ss format? Text, obviously. I'm using Excel 2010 on a Windows 10 PC. 35m 22s25m 37s30m 48s2m 59s18m 39s19m 24s38m 39s21m 54s5m 19s17m 8s26m...

Excel Version = 365 OS = Windows Hi Everybody, Still New to the whole Power Pivot thing so please bare with me as I will have a lot of Obvious Questions that might seem stupid. Summary: I have Engineers that work on Work Orders, Each Work Order has a Start Date, Start Time and a End Date...

In column B it prints the current time whenever the value changes in column A. I am using condition like if the current time is greater than> 1 min then prints the value in column a . the problem is I want to run the code exactly at 15 sec every min like 9:15:15, 9:16:15, 9:17:15 ...somehow it...

Hi All, I'm trying to write a formula that is going to calculate time to finish parts in hours, for example i have 35000 parts making 550 per hour how long is going to take me to finish it in hours and minutes. I tried changing the numeric to time but its working only in 24h time it doesnt give...

Hello, I create a macro to calculate the time travel between two times which are attendance records; To calculate the difference between B and A So in this case we havec 3 conditions : - B is greater than A so you can make de substraction - Or B is less than A so it's an error from the...

I am having an issue trying to find a formula to subtract minutes from hours based off the formulas I have used to sum the time remaining. I am trying to sum the times in E5 and E6 into cell E3. B5: =LEFT(B3,FIND(":",B3)-1) C5: =LEFT(C3,FIND(":",C3)-1) D5: =LEFT(D3,FIND(":",D3)-1) E5...

Hi all! Another questing regarding the call centre data I am working with. Similar question to my last post, thanks again to Joe4 for their awesome response/formula! In this problem, I am needing to assign a Time Period Category (column A) to the Start Time (column B) of the inbound call to...

Hi, I'm trying to calculate the finish date and time of a production run but excluding hours the factory doesn't work. I have the start date + time and the production hours needed, please help!!!!!

Hi everyone, Trying to get the average processing time of coloumn K but I get a #DIV/0! error. Does anyone know what could be wrong? Both coloumns are formatted as TIME values but K is still text when using =ISTEXT. Formula =AVERAGE(K2:K10) I get a #VALUE! error when using this formula...

Hey guys, ** Context ** I work in television advertising, where we have to make sure that none of our spots (ie. the times when our ads are showing) are playing on the same station (channel) within a 16 minute interval. Each week, we copy all of the spots (often tens of thousands) that we have...

Hi Everybody, I'm new on the board. I have a problem with ovelapping time and impossible to find a good solution. I need to display the start hour and end hour of overlapping. Bellow a sample: The "What I need" column, is what I need ;) The row 2 is the reference time for overlapping. The...

Hi There, I am trying to solve the problem with coloring the shapes based on time and I am struggling with it for some time so hope someone can help me with this. I have 19 shapes on excel sheet and each is having the name Bankomat_ and then number from 1 to 19. The output should be that...

I've formatted my cells as time. When I enter 3:15 Excel converts it to 3:15 AM. That's ok. But if I input 3:15 PM Excel accepts it as text. If I type 15:15 Excel properly converts is to 3:15 PM. I have no idea why I can't type the AM or PM and have Excel accept the value as a time.

Thanks in advance for any ideas you may have on my issue here: I have column ("times,") formatted as time (XX:XX:XX AM/PM) that has times in it. I have a second column ("times round,") that is referring to the first one and is ROUNDING (down) those times to 30 minutes (and formatted the same)...

Greetings All - Thank you for giving my problem a look: I have column ("times,") formatted as time (XX:XX:XX AM/PM) that has times in it. I have a second column ("times round,") that is referring to the first one and is ROUNDING (down) those times to 30 minutes (and formatted the same). I have...

Hi Floks, I am writing code for the incrementing the A1 cell value till the cell A2 and display it in A3(time format). EX: I have a value of in cell A1= 2020.01 and in cell A2= 5 YEARS. A3 cell should display like. 2021.01,2022.01,2023.01,2024.01,2025.01

Hello! I have an excel file containing a collection of costs and what I would like to do is to have a timestamp updated in cell B2, whenever the total sum of cost is updated in B4. B4 contains a SUMIFS formula to add all the information entered in that sheet. Now I searched highs and lows for a...