difference

Hi Everyone, for some reason pulling a blank on this. Two cells D3 & G3 I want to see the difference if its more than 1p (0.01) but show 0 id not please help Thanks Tony

Hi all. I'm attempting to work out the difference between two date and times. Scenario: I work in IT and 'm an SLA manager. I've been tasked with finding SLA compliance between incidents raised and initial incident response. Normally this would be fairly simple, however the SLA 'clock' only...

I am in need of advice / assistance I have a table with 2 Columns showing times . I am trying to show in one cell the average difference of those two columns I could create another column to show the difference for each row, and then average just that column .. but I would like to not have...

Hi, My head has been pickled trying to figure this out, here's the problem (it's also on google sheets): I am trying to show a live production rate which is based on time and units completed. Start time in the morning is 8am I have a cell which shows the live time beside it Below this I need...

hi, does anybody knows what is difference between TRUNC and ROUNDDOWN functions in excel? except optional or required for second argument

Hello everyone, I have a simple request. I have 4 different times and I need a cell to display the difference between these 4 times in percentage. For example If time is 1:00 1:00 1:00 1:00 it should display 100% because time is same 0:45 0:50 1:00 1:10 it should display...

I understand Conditional Formatting on reports in MS Access.......but in Excel it throws me. Plus, I don't use Excel nearly as much as Access. I can do basic formulas, no problem. Getting fancy starts causing problems. I have a cell (T50) that is calculating the difference between cells R16...

i'm genuinely curious....does eliminating "selecting" and declaring variables really make a difference with performance nowadays? sometimes i get this feel people that just say selecting is the root of all evil cause it screams recorded code ....but from my experience (but maybe the macros I...

I have a set of financials that link to a PPT for our monthly presentations. Each fiscal year we create a new excel WB. Everything is exactly the same, the only difference is the name of the file. So instead of the excel file saying FY18, it now says FY19 Is there a way to point the PPT to...

Hey guys! I have 2 columns with the following time-format: Column 1: hhmmss (223000) Column 2: hhmmss (234000) Now, how can I get the difference between them? It would be 50min (5000). Do you have any suggestions? best regards!

Hi, Can any one help e out, i am trying to create Macro file which can compare two identical excel reports (Workbook) and generate difference report with same layout and formatting. Thanks Satyartha

I have times in my sheet and for some reason one of the entries of 11AM is apparently not same as other 11AM. Attached is the sheet that shows that there is a difference and I cannot seem to figure out why. Any suggestions for avoiding this as such issues alter the results. Here is the file...

Dears, Help me in making one Button which I press enter the time in B10 and Press again it will enter in C10 with time difference in D10. And when I press again it will enter time in B11 and if I press again it will enter in C11 and time difference automatically in D11 and keep on going if I...

I got a template layout and i normally copy and paste all customer data in my template and saved. However, a lot of time customer send me new file with the same data but they added in few new data or inserted new row between old data. I have code that scans and compares old excel list with...

A2=6/27/2018 9:59:32 B2=6/27/2018 10:58:38 In C2 TIME difference in seconds is required. How to accomplish? Thanks in adv

Hi What is the difference between Form Controls and Activex Control? Why we have both? Thank you very much.

I've got a big forecast model, which takes about 5 secs to calculate. There's a lot of formulae that do SUMIFS with 4-5 parameters and I want to make it more visible what it's doing so other people can use it. is there much difference in referencing the ranges directly, or using dynamic...

In column B I have a list of times in h:mm:ss format and in column C I have a list of times in the same format. In column D I have the difference between the 2; Column B minus Column C. If column C is less it gives me the difference, but if column C is more oft gives me an error? Also in...

I have these job levels (in order) with their corresponding average salaries, earlier job level salaries, difference in $ and % between the two. This is a manual table, and I need a DAX formula to calculate the earlier job level salary so that I can calculate the differences, but I can't for the...