text & date/time in cell

I am looking to clean up the conditional formatting as this document will be used on multiple projects moving forward. I am wanting to know if it is possible to have the rule CONTAINING TEXT 'FORMAT ONLY CELLS THAT CONTAIN" for; 'Cell Value contains = $R$8 to instead be Cell Value contains...

I'm working on a break list for my team at work. I want a very simple calculation to count the values in cells and return their number, with the text "currently on break: " in front of it. If I just use =SUM(C4:C16) it works perfect and returns me the number, but using ="Currently on Break...

I have a Column that stores a cumulative time value as 95:31:00 (for example) that is of the format [h]:mm:ss. I am needing to convert this to a Text / String value which i know can be done using the worksheet function Text(timeval, "[hh]:mm:ss"), but i am curious if the same can be accomplished...

Hello I have downloaded a report and the date in the above format stored as text. I would like to change it 15/10/2019 to create a Pivot table. I have tried datevalve, format the cell to date but no joy. Any pointer please. thank you.

I have a list of times which were bought over as Text, so the date is 01/01/1900. I want to update the date to todays date. Tried this: =DAY(H2)+MONTH(H2)+YEAR(H2)+HOUR(A9)+MINUTE(A9)+SECOND(A9) which gives me a 1905 year date As well as...

Hello Everyone, So I created a drop down menu with the days of the week on it. Now I want to be able to alter a cells data to read a time per each day. =IF(K21="Friday","4:00pm") This formula works and hypothetically I should just be able to repeat this a bunch of times but for some reason...

Hi, I have the text strings in the following format in my excel sheet: joey/ Date 08-17/2016/ the quick brown fox/On 2014-12-03, "ABC" debses/Asset category: Equity/balanced.- Now, I want to extract the second date i.e. 2014-12-03 in a separate column from the string above. Could someone...

Hello, Please if anyone can help. I think this is possible without a VBA but I can't figure it out. I want a cell coded with a custom date format and general formatting. In a cell lets say S1 I tried making up this formal. =W1&" - "&A2&" "&VLOOKUP(Q2,AB5:AC28,2,FALSE)&" "&X1&" PRODUCTION" The...

Hello, i am wondering if it is possible to assign the text value of a range to a variant. So normally as shown below Dim v as variant v = Range("A1:B100").Value2 However, if I have dates or times in the range, and would like to assign the values with their formats to the variant array. Any...

Is there any way I can convert this text <tbody> May 31 2015 6:17PM Into a date and time. Thank you in advanced </tbody>

A popular product has an Export to Excel with a single column for Date / Time. The format shown has the date [comma] Time. It won't convert to a Date date type due to the comma. A popular software tool takes this data off of the internet and converts it to this text string. I can manually use...

I have punched a date time value in cell C1. How to check that Excel should not be treating it as a text. It should treat it as a value only.

I am attempting to extract a date from a cell that is in string format using a particular VLOOKUP. This is the VLOOPUP statement (it works!) Target.Offset(0, 20) = Evaluate("=VLOOKUP(" & Chr(34) & Target.Value & Chr(34) & ",'[Volume Alerts.xlsm] Data'!$A:$W,20,FALSE)") The date is showing in...

Hi, I am trying to put in a formula to auto update my week number so my spreadsheet is one week in advance, I know to make it this week I use this formula: =CONCATENATE("WEEK:",WEEKNUM(TODAY())) My question is how do I take it from this week showing "WEEK 35" to working in advance so it would...

Hello Everybody, I went through few posts online about my query but couldnt find anyhting specific. Please help me out I am trying to find a particular text in finite range using macro. I am first finding all the dates in the previous week and putting the values in column B (7 Values - B1:B7)...

Hi I have looked at a number of posts regarding splitting out date/time stings to separate cells, but I cannot find how to split the following. I have the serviceable date of an aircraft delivery set as 'S hh:mm dd-mmm-yy', which is due to being used by an external application in this...