time

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

I am tracking time for short projects and having trouble with rounding to the nearest quarter hour. I am not sure why, but sometimes projects that are exactly 15 minutes round up to the next quarter hour and sometimes it remains at 15. I would like projects of 15 minutes or less to bill at 15...

Hello, I have a sheet of data in excel and I need to get the total minutes engaged per user. Most the users have a single row hosting their start and stop times. (Cell B1=UserName; B2=StartDateTime; B3=StopDateTime). I can get total number of minutes pretty easy from that, so no issue...

Hi, i hope someone can help me. I try something similar as already described here: Splitting activity duration by half an hour intervals I too have a long list of activities and their start and end times. What I need is to split the duration of each activity into hourly intervals. At "Normal"...

Hi, Example of my 200k row data: ABCDE1TimeA21:00:00.0001.52:00531:30:00.0001.542:00:00.0001.252:01:00.0001.262:45:00.0001.372:50:00.0001.382:55:00.0001.592:59:00.0001.5102:59:08.0001.9112:59:59.0001.9122:59:59.0201.4133:00:00.0001.11422:00:00.0001.4A Column : Time B Column : Value D Column ...

Hi all, I am very new to VBA. I would like my code add a comment box to the active cell based on the text in the active cell. As the user inputs code it should add a comment. However when users move down the sheet and populate the rows it seems that the code takes longer to execute. Any help...

Hi, I have below Hours:Minutes:Seconds from Excel file 01-02-2021 33:05:51 01-02-2021 14:50:45 01-02-2021 11:19:14 01-02-2021 11:48:32 01-02-2021 07:58:32 01-02-2021 17:08:31 When showing in Power BI in matrix it returns the following: I don't know why, but I can't select sum...

Hi all, so my problem is this. I want to basically make the attached picture in excel. What this shows is a 24 hour day, divided into various chunks of X hours. This I can kind of do with a multiple-series donut chart (I need multiple concentric wedges), however the bands are WAY too thin and...

Hi All, I'm running a study where I measure car speeds passing a speed detection device. The device records speeds and spits out one excel spreadsheet per date. I've put together all the spreadsheets using PowerQuery in Excel which has worked nicely. The problems start to arise with the fact...

I am working on a staff schedule budget. I am trying to calculate based on budget and rate how may hours an employee can work. Here is the catch, while an employee may get a budget of $2889.00 at a rate of $15.00/hr which would give them 192.6 hours. However, since our timesheet system only...

Hi, I have a schedule of employees, that works in shifts. But i want to count how many people are working between 07:00 and 12:00 and between 12:00 and 16:00 and between 16:00 and 20:00 How can i do that, the begin time is in a cell and the end time is in the cell next to it. see down...

I'm struggling to come up with a formula that will look at the start time and subtract it from the end time (if the dates are the same) and if the difference is 1 minute or 30 minutes, color it green. I've tried googling this and have not come up with anything that works at all. I'm hoping that...

Every day I produce a spreadsheet (not of my own design) to report on the vaccination of our workforce. It needs to be out by 7:30 a.m. The raw data is available at 10pm the night before in 4 CSV files. I have 1 macro that imports the new info onto a sheet called "Data", and another macro that...

In Google Sheets I have a column that checks another two column's and calculates the difference. I already have it conditionally formatting to be green or red depending on the difference being less than or equal to 0, and greater than 0 respectively, but I specifically want to have it display...