pace

Hey all - just a basic question that I'm blanking on for some reason... I have a pivot table that refreshes that shows me how many units I have sold through out the year with the total units sold in cell F75. I have another calculation in cell G76 that shows me what % of the way we are through...

Hi All, I'm finally surrendering for assistance. I've been a long time lurker and this forum has been a an amazing resource :). I'm trying to calculate the pace of a digital campaign I'm running based on the current date. Below is a sample of what I'm trying to implement. I am not attempting...

The formula I have in place is =E1/DAY(TODAY())*31 for January. This works great as long as we don't close for a day in the month. Of course we were closed January 1st. How can i make my current formula not calculate jan 1st in the pace? Thanks.

Hi, I have a pace set up for our sales department. The formula I have in place is =E1/DAY(TODAY())*31 for January. Of course we were closed for the 1st so now my pace is off because it is thinking we have worked everyday but really we were off for the 1st. Any idea how I correct it so it...

I have sheet of times in time format, lets say in seconds, like following.. A1=100 seconds A2=200 seconds A3=300 seconds in B column, I have a divide calculation that converts seconds to wanted time format (ex.hours), =A1/3600, so values are B1=0,027.. B2=0,055.. etc. I also have total row...

Hi, I need some help in this, below is my query. I'm looking at creating a sheet by which i can calculate the total time and pace for a marathon based on the time taken (pace) per mile. To illustrate this, let's say Mile 1 - 9:00 Mile 2 - 8:45 Mile 3 - 8:40 Mile 4 - 8:30 Mile 5 - 9:30 Mile 6 -...