24hr

  1. H

    Counting the Number of a certain job code working in each hour w/ 24hr

    I am trying to set up a workbook to count the number of each job class that is working at a certain time, I am using this formula: =COUNTIFS(Data!$AA:$AA,Daily!$A3,Data!$J:$J,Daily!$C3,Data!$S:$S,"<="&Daily!E$1,Data!$V:$V,">="&Daily!E$2) Data!$AA:$AA= jobcode Daily!$a3= Jobcode I want to count...
  2. ClimoC

    Over 24:00 problem

    I know what someone is going to think... "[h]:mm:ss" That's not the problem. The finished sheet is a file for importing to third party software. It doesn't handle the "01/01/1900" that is appended to the time when it goes passed 24hrs. Hundreds of lines of code, do not want to remove them...
  3. 5

    Formula Issues - Time 24Hr Clock

    <TABLE style="WIDTH: 275pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=366 border=0 x:str><COLGROUP><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><COL...

This Week's Hot Topics

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
Top