If you look in the formula bar of any of the cells in Sheet 1 column J you
may see that by formatting the cell to (MM) you have converted the 01 data to
a date which is now represented as 01/01/1900, therefore your formula which
is looking for instances of 01 will find nothing, play with the format of
column J or alter the formula in sheet 2 thro 60 to look for the appropriate
date



"Sapphyre" wrote:

Ok, I finally got a formula/format to work for subtracting my date/time
columns and my total minutes column on my main sheet1. On another sheet
within my workbook I calculate different information that I get from my main
sheet.

This is how I use to have my sheet2 column B
=COUNTIF(Sheet1!J2:J2500,"01") formatted-General
This would calculate how many times column J from Sheet1 had a 01 occurance.
I did this all the way through 60.
But now that I have changed my sheet1 J column with this formula
=H2-G2 and formatted [mm] it won't calculate on my sheet2 right anymore
useing that above formula/format. I've tried formatting the sheet2 column B
with [mm] but that doesn't work either.

It's like I fix one problem (subtracting date/times <,=,24 hours) and
created a new problem :(.

It would be most appreciated if someone could help me with this.

Thank you so much,
Sapphyre