Search results for query: *

Managed it thanks (CAST([batch end] AS float) - CAST([batch start] AS float)) * 24 * 3600 /60 - (downtime/60 + [pntr time]/60)

Hi I managed to get most sorted but I am stuck on one row of coding (CAST([batch end] AS float) - CAST([batch start] AS float)) * 24 * 3600 - (downtime + [pntr time]) AS Runtime This gives me a result of 25098.5339996806 however I need to divide this by 60 to get 418.30. I have tried to...

Hi I have a field that the results show in seconds. I want to display this in minutes and seconds but unsure how to do this. downtime AS Downtime is the filed name and the result for example on one record is 2299.35800027848 I want that to show the result 2299.35800027848 / 60 which I...

Hi I managed to get it working. I did the numbering for the Type The I did a Running Total count on only the Process which gave me the number 1,2,3,4,5 I then suppressed the Group other than 1 and 2 Long winded maybe but it worked.

I managed to get it working. I did the numbering for the Type The I did a Running Total count on only the Process which gave me the number 1,2,3,4,5 I then suppressed the Group other than 1 and 2 Long winded maybe but it worked.

Hi I have made another thread as I feel my last one as become complicated than it needs to be I have forumla that does as below for Source = 1 and Finished = 6, I want Processed to be numbered 2 to 5 (there are always just 4 processes) and then select only numbers 2 and 3 to display in my...

Another idea which may make if simple or not, I could create a forumla that does as below for Source and Finished = 6, however how do I get it it to number the Source from 2 to 5 starting in the order they list in. If {@FormattedLineType} = 'Source' then 1 If {@FormattedLineType} = 'Process'...

Well my doe worked for a short period however using Running Total field with a distinct count Product Code and on change of field set to WO Number. I have 3 types of lines Source Process Finished The source was keeping everything at number 1 in the total field, 2,3,4,5 for the process and 6...

Figured it out I believe, The spreadsheet was linked to a SQL View and the field it was using was VarChar. I did a CAST and changed it to INT. The spreadsheet is working as expected now. Thanks for the replies

Hi The column is set to General and not text as per the video. So the options are not available to convert when I highlight the column in anyway. Thanks

Hi Thanks for the reply, I have actually tried changing the formant of the column to number instead of general, even tried text but I am getting the same result each time unfortunately

Hi I have a Pivot table which as a filed for the rows called ProdGroup. It as numbers from 1 to 12 and I have managed to do the totals and subtotals on each group. However the numbers for the columns are out of number order, so instead of going from 1 to 12 it is putting the 1's first so I...

Hi I have a long list of dates in 2 columns and want to calculate the days between them but exclude weekends and bank holidays. I have used =NETWORKDAYS(F2,G2,P2:P10) The P2:P10 have the bank holiday dates in but when I copy the formula down it changes for example =NETWORKDAYS(F3,G3,P3:P11)...

Thanks for the reply I ended up with this code with No Suppress If {#Row No} <> 1 and {#Row No} <> 2 and {#Row No} <> 3 AND {@FormattedLineType} = 'Process' THEN True Thanks

Sorry my issue as changed since the first post. I managed to add in distinct row numbers which worked. However I now need to include a Line type which is named Source, Process and Finished. I need to show the rows with Line Type Source and Finished and only the first 2 rows of Process in one...

Hi I have a report that is grouped by orderlines. The orders may have up to 6 rows or mote. However, I want to create 2 sperate reports. One report that only shows the first 2 rows of the orderlines and hide the rest The other report to only show the 3rd and fourth row of the orederlines and...

Hi Its ok managed it I used =TEXTSPLIT(A2,";") Thanks

Hi I have a large spreadsheet that as one column with all the information. I want to spilt the data into different columns before and after a ; appears (example line below). I have looked for Trim commands on google but cannot find anything quite what I am after. Could some assist please...

Perfect, works well many thanks for all your replies very useful as always

Oh god I am so stupid of course I had it the wrong way round. Got it now, one more question if you don't mind, how can I make the VLOOKUP populate the column where data exists =VLOOKUP(D2,I:J,2,FALSE) is how I have it, I may have 1200 rows so could put in =VLOOKUP(D2:D2000,I:J,2,FALSE but the...