Time

  • Thread starter Thread starter Troy
  • Start date Start date
Troy,

Use a custom number format of [hh]:mm or [hh]:mm:ss .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
This does work except for on the sheet that is linked to
the original sheet. It won't go past 24:00. That cell also
is formatted to [hh]:mm but it won't work.
-----Original Message-----
Troy,

Use a custom number format of [hh]:mm or [hh]:mm:ss .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)


When I enter 26:00,excell displays 2:00 I need it not to
change. Is this possible
Click to expand...


.
Click to expand...
 
This right here would solve everything if I can select a
range and then sum everyother cell. This would work
perfectly.
 
Try

=SUMPRODUCT((MOD(ROW(A1:A100),2)=1)*(A1:A100)

for cell A1, A3, A5 and so on, for A2, A4, A6 and so on use

=SUMPRODUCT((MOD(ROW(A1:A100),2)=0)*(A1:A100))
 
Sorry for not being more specific but this is what I need
Sheet 1:
AI7:AI1000 recalls the numeric month number from A7:A1000

Sheet 2 (Totals):
Monthly Totals
When AI7:AI1000 is equal to (for example) month 4 the get
the total of everyother cell beginning at B7:B1000 for the
month 4 corresponding cells.
I hope this isn't too confusing.
 
One way

=SUMPRODUCT((MOD(ROW(B7:B1000),2)=1)*(MONTH(AI7:AI1000)=4),B7:B1000)

will sum B7, B9 and so on if AI7, AI9 are April
 
Back
Top