One point to note is that by putting quote marks around the "01" in your
formula, you are looking for cells whose content is 01 as a text string. It
won't find numbers. If you're going to do it that way, you would need to
make your formula in column J look like:
=TEXT(H2-G2,"mm")
--
David Biddulph

"Sapphyre" wrote in message
...
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