in what way didn't it work?
if you find an example in the j column which shows 1 (Jxx) what happens when
you use the equation
=minute(Jxx)
if it is not 1 what happens when you change the format of column J?

"Sapphyre" wrote:

Thanks for the reply bj. I tried your suggestion and it didn't work. I'll
keep at it though...I know there has to be a solution :)

"bj" wrote:

maybe
=sumproduct(--(minute(Sheet1!J2:J2500)=1))



9

"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