# calcualtion

1. ### Calculate the difference in hours in a range write in a multiplelines

I have a situation like this: In one cell, I split the time ranges over several lines, for example 07: 15-10: 27 10: 35-11: 00 11: 15-12: 27 13: 15-13: 27 14: 15-18: 27 19: 15-20: 27 21: 15-23: 39 I know it would be more logical to have an hourly range divided over several lines, unfortunately I...
2. ### Calculating Pace using Days Passed

I am looking for a way to use the number of working days passed to figure sales pace on a daily basis. I have the formula already to use (total sales) / # of working days passed * # of selling days in the month. I added a helper field for both areas to represent number of days passed, but not...
3. ### VBA not completing calculations before moving to the next process

Okay so apologies if this doesn't make much sense, Mr Excel newbie here... I have a huge problem as I'm trying to automate a report and the report involved holds critical data for daily usage. The problem I'm having is in column A on one of my worksheets (Tails) there is a formula array...
4. ### Nested Excel IF Statement Issues

Hello, I am having problems trying to get this statement to work; specifically for the portion that is supposed to look for any numbers between 1 and 2 and then perform the calcualtion. Can someone take a look to see what I am doing incorrectly? Thanking you in advance. =IF(B38<1,0...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back