crosses

  1. P

    Time band hour count

    I am looking for a formula to look in times in A1 and A2 (A1 has start time and A2 has finish time and tell me how much of that time crosses over the hours between 1800 and 0600 Example A1 = 2200 A2= 0800 answer would be 8 hours Any help appreciated
  2. R

    headcount by hour spanning midnight

    Hello, I am looking for a formula/method to calculate the headcount by hour of day. I have employees whose shift crosses midnight hours. e.g. employee Start End A 06:00 14:30 B 14:00 22:30 C 22:00 06:30 Now I would...
  3. M

    x-y grid lines in graph

    Hi, I am trying to format a graph so that the x and y axis are identical to a Cartesian plain. So the Y axis crosses the X axis at the origin. It seems that I can't get this to work. I tried highlighting the Y axis and going to properties, then changing the min and max from auto to fixed...
  4. S

    Formula Help

    Hi, I have a column of data that contains ticks and crosses (P and O values using Windings 2 font). What I want to do is a count of how many cells in the column contact ticks and how many contain crosses. Can someone help with the formula?

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top