I want to take this sort of table:
and convert it into this kind of table:
How would I do that? Any...
Hello Excel Masters
I'm looking for a formula to convert the below text in cell A1 into the date Mar 20
A1 = March 20, 2023 at 10:21AM
The formula needs to work for any month and day, for example in 6 months the formula would convert September 21, 2023 at 11:21AM
Thank you in advance
have a question related to covert number of calls from a cumulative total per day to a calls per hour like this.... Calls that need to be converted to hourly are on cells B3 to G23.
As example we take B3 = 25 and try to split on cells B12 to B14 with this formula...
I'm trying to convert a historical date to the same date in U.S. Government fiscal year 2022 and could use some help with the formula. For illustration, I've provided below a sample historical date which I want to convert to the same date in FY22.
Sample historical date: 07/23/01
Hi! New user to Power BI here and trying to learn how to convert a whole number to a HH:MM:SS format. I've done quite a bit of research but can't seem to find an exact solution online for what I need. I'm currently screening transaction ledgers and the date/time stamp is significantly important...
Having some problems getting the correct month and days to populate.
Does anyone have a good formula to convert a 4 digit Julian date and copy the time over from one cell to the adjacent cell.
data I have: 2182/0950 (yddd/hhmm)
conversion I am trying to achieve: 1 July/0950
I am trying to convert the START and END latitude and longitude coordinates I have into nautical miles. I read here that I had to convert my latitude and longitude (in degrees) to radians which I did by using the =RADIANS function. My situation is as follows:
I have a start and finish lat and...
Hi i have an macro that saves a pdf and then emails out statements. But on conversion from 2013 to 365 it no longer works.
Could anyone have a look over the code and see if they can see what the issue is i.e. whats changed between versions that i need to update?
Any help appreciated.
I'm trying to calculate the impact three ever changing variables are having on our month on month performance. We have 10 buckets that are filled with applications and the scenario is:
The total number of applications changes month on month
The % of total applications that sit...
Is there a macro I can use that would convert this...
The column will have always data in Column A and rows could vary in terms of data input.
I have a table to be filled in with the prices of some products from different offers. Some products are acquired in the Euro currency and the others in the RON currency. My question is if is any possibility (macros, formulas) so that when I insert the value expressed in one currency...
Has anyone got/seen/aware of a batch conversion tool that I can use to get the 10km OS Grid ref from a list of Northings and easting? I've a list that's 3,000 long so can't contemplate doing them manually/singularly using the tools I can see online and don't know where to start to...
Since I installed office 2019 Excel I got data conversion problem when opening a CSV file.
when opening a genuine csv file form bank or postal account some lines show data on conol B or C
So if a run data conversion I got a message telling that this action will...
I'm trying to setup a macro that will allow me to upload a spreadsheet "ABC.xlsx" each time I run it; however, I keep getting a conversion error. The reason appears to be some data is not yet populated (blanks). Is there a way to import the data so everything is short text so everything...
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
I'm importing dates that look like this.
I'm trying to get -
Any of these will do...
I'm trying to convert a model that has a complex sumproduct formula:
And once the column count gets to 31 (range of AX->CB...BX->DB), I get the following error:
"SUMPRODUCT has mismatched range sizes. Expected...
I have data which looks like this -
Using this formula I can convert these to -
But what I'm really looking for is -
I'm happy to use an extra column to achieve my goal but
if it can...