time

I work at an office and we share an excel spreadsheet. We check in column D, i want to find a way to make the color change red after 5 minutes of checking them in. Is there anyway to do this?

Hi everyone, I've got a problem with some data I exported. The numbers in columns B through E are supposed to be seconds, but they look weird. There are milliseconds added after the dots. Some of the values are lined up to the left and have the cell format "general". How can I fix this and...

Hi Team, I am creating a calendar view to show room bookings and have been able to pull through the start and end time of the event, I now just want to show the cells in between as highlighted. As you can see below, the Investor Event starts at 8 and finishes at 17:30, I would like the cells in...

Hi All, Hoping someone has an easy solution to decipher if hours worked by an individual fall into the day shift (0600 - 1800) or night shift (1800 - 0600). The issue I'm having is that if someone has worked across both shifts, I need to be able to split these according to what shift they fit...

I’m trying to count employees per hour but the problem I have is that we have people clocking in and staying past 12AM. Current Formula: =sum(((A2>=$B$2:$B$32)*(A2<=$C$2:$C$32))) A2 is the time of day so 12am,A3 is 1am so on and so forth B column is the start times of the employee and C...

dear all, I'm currently stuck with Excel and I hope you guys can help me. I am looking to lock specific rows (in the screenshot: the forecast quantity) D6-O6, D9-O9, D12-O12, D15-O15, etc (until D24-O24) after a specific date has passed. This date will be defined in D3-O6. So the way it...

Lyft formats my times booked & online in the format below. Is there any way (no VBA scripts, please) to massage this data so that columns E & F can show a usable sum at the bottom? Maybe in the same format, total minutes only, or even add columns to separate hours and minutes for each. I realize...

Hi, Been a while since I've been stumped, and I'm sure its easier than I'm making it out to be I want to highlight the cells C2:H5 based on if the row header is within the time range A:B relative to the row of coarse Any help would be great, i know i ts a conditional formation by...

I've looked around and have tried other solutions I've seen posted for similar questions but none have worked completely. This is a sample of the data. Formula for day hours currently is: =MAX(,MIN(D2,IF(B2<A2,1,)+B2)-MAX(A2,C2)) Night hours: =E2-F2 It appears to work in all day shift start...

Excel 2019 In cell A1 we have timestamp 23/06/2018 12:02:18 No in cell B2 we want to add four hours in but if timestamp is 23/06/2018 14:00:00 and office open and close time is 11:00 am to 5:00 pm then it will add four hours, according to office working hours 24/06/2018 13:00:00 and if...

Greetings, Can someone please help me with a formula in excel to export only the hour, for example column A says 5:31:02 AM, I would like column B to say 5:00:00 AM? Thanks in advance

I'm trying to use VBA to automate a process I perform multiple times a day. I've figured out a little bit but I've got 2 different columns containing time. The estimated time is sometimes populated so I want to be able to filter on 2 conditions: either ET (Estimated Time) is populated and...

I am trying to use a basic formula D2+E2, but it wont add the time right. It should say 2:07 for time stop. (2:07+00:00) but it says 7 minutes. Any ideas why?

I am trying to create an IF statement that reads "Valid" if the current time is between the hours of 10AM and 3PM. To do this my idea was to have an isolated cell which contains a formula which displays exclusively the current time that can then be referenced in said IF statement. However, I...

Hi! This is my first post here and I am sorry if the question has already been asked and answered. Couldn't find anything for this. Anyways! I can't figure out how to get the % total of hours worked. The formula for total is: =SUM(L85:R85) ,for example. How do I make that into percent if a the...

For quality analysis I want to select a random 20 minutes from a 80-minute rugby game. How do I customise the '=TEXT(RAND(), "MM:SS")' so that its giving me a starting number between 0.00 and 80.00?

Hi. I have a spreadsheet with two sheets, Sheet1 holds my main data set which is an audit trail of incident assignments each row representing an assignment to a support group. The key columns are Incident Number (column A), Assignment Start Date/Time (column B) and Assignment End Date/Time...

Okay, So I have a document I have been building for a schedule. I have a control sheet that has all the control data, then Base Data which has the same data plus different times for different time zones. Then I have other sheets that have the same data but are related to their time zone. It...

I have a spreadsheet that is generated nightly by our ERP system and I think the timestamps are being entered in 2 different way, or something? When I try to pivot the table, I can't group the time nor sort it by time. I've tried every different time format but nothing seems to work. I think...

17:58:282020-08-02LocationDim LevelCHANGE17:57:092020-08-02xOffOn to Off17:06:452020-08-02xOnOn16:45:362020-08-02xOffOn to Off08:15:032020-08-02xOnOn02:43:522020-08-02xOffOff02:33:502020-08-02xOffOn to...