time

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

In cell A1 I insert the date In cell A2 I have the command =CHOOSE(WEEKDAY(A1),"SUN","MON","TUE","WED","THU","FRI","SAT") In cell A3 I insert the worker IN time and in cell A2 the out time ( in mm:ss AM/PM format ) In Cell A4 I need the following results, can anyone please help me with the...

I'm trying to conditionally format a row based on if the time in column R exceeds an hour. I calculated column R with formula M2-P2 but M and P are two columns with time in different formats. The calculated times in column R appear correct but aren't formatting correctly based on my conditional...

Hi All, can you please help me with the following question: I can’t figure out how to calculate the time in Column A to get 8hrs in Column B. Is there a formula I can use in Column B that will give me 8hrs? Thanks! Column A Column B 7am - 3pm ??

Hi, I have a large data ranging between 200k-400k row every weekday to analyze. I need to get result for Column P, Q, R, S, T, U , V, W, X, Y from Row 2 to Row 7201 (sometimes until Row 1441 , 481 ,241 ,121 depend on what kind of analyze is). Current formula I use is "...

Good Afternoon, I want to create an Excel Spreadsheet which automatically closes after a certain time of being idle as multiple users need access to it. I have found coding for that but unfortunately for it to work Macros need to be enabled. I have found what I need which works separately but...

Hi all, I am looking for an efficient way to calculate the error time from a sheet of data based on the name column (B). When the value of a certain error is 1, the error is started and when the value is 0, the error is solved (column C). There are a lot of different errors, which sometimes...

Hi all, I am trying to get a yes/no answer if a cell is between a time range. It is set up as a table on Office 365. I have tried IF and IFS statements with both AND and TIMEVALUE in it. I have attached a screen grab of what i'm working with at the moment. Any help is greatly appreciated. Chris