Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: inspekta76
  • Content: Threads
  • Order by date
  1. inspekta76

    Need to copy formula sheet w/o reference to other file

    I've searched here, there everywhere and tried 50 different ways to do this with absolutely no luck!!!!!!!!!!!!!! I have a monthly file with a worksheet for each day and at the end there is a summary worksheet-with formulas cumulating the values for the month. When I try to copy that worksheet...
  2. inspekta76

    MAX formula not recognizing a time continuation from day before

    I have a MAX formula calculating the difference in time frames and selecting the greater of the two. i.e. =MAX(I23-E23,I23-D23) I23 is 02:52 (End of service time) E23 is 02:12 (ATA) D23 is 22:15 (ETA-from the night before) the answer in K23 is 40 but it should be 277 my problem is that the...
  3. inspekta76

    Converting minutes to 100th of hour

    D1-custom[mm] - has the sum total of minutes from A1:C1 all custom[mm](I am calculating minutes gone by) so we'll say that number is 200 E1-formula =D1-custom[h].mm which shows as 3.2 I need it to show 3.33 (as per a 100 minute clock)-this is used for billing purposes I've tried =D1/60...
  4. inspekta76

    Formula for selecting greater of two values

    HERE GOES...column at top ETA(A1) ATA(B1) END(C1) TIME(D1) 10:15 10:30 10:46 16 =HOUR(C1-B1)*60+MINUTE(C1-B1) So normally I need the C1-B1 for stats...but IF C1-A1 is greater then I need that number-PLEASE HELP. The formula I have in D1 is to convert the time...
  5. inspekta76

    Grouping and Totaling Text Data

    What I have in my report Division Type # of Type Div.Tot. Share% A Good 1 1 Good 1 1 Good 1 1 Bad 1...

Part and Inventory Search

Back
Top