Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format Problem | Excel Discussion (Misc queries) | |||
Format Problem | Excel Discussion (Misc queries) | |||
Format problem | Excel Discussion (Misc queries) | |||
Format of cells problem... | Excel Discussion (Misc queries) | |||
Problem with txt format | Excel Discussion (Misc queries) |