LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default Value of minutes not calculated

I have the following in a spreadsheet. Everything works great except
the last column, the Total [=SUM(E3+I3+K3+M3+O3)]. The value of cell
I3 is being totally ignored. Thanks for any help.

Column headings:
Team Name
"Starting km"
"Finishing km"
Total km
"Penalty Points Official Distance 117km 1 penalty point for Each km
over/under"
Start Time
Finish Time
Total Time
"Penalty Points Official Length 175 minutes (2h 55m) 1 pt p/m if late
2 pts p/m if early"
Panics opened
Penalties Panics x10
"Wrong side of Envelope opened"
Penalties Envelope x10
"Incorrect/Incomplete Puzzles"
Penalties Puzzles x3
Totals


The data:

Dancer 28502 28642 =SUM(C3-B3) =IF(D3=0,0,ABS(D3-117))
0.736805555555556 0.881944444444445 =SUM(G3-F3)*24*60
=IF(H3=0,0,IF(H3<175,(((175-H3)*2)/1440),IF(H3175,((H3-175)/
1440),IF(H3=175,0)))) 1 =SUM(J3*10) 4 =SUM(L3*10) 0 =SUM(N3*3)
=SUM(E3+I3+K3+M3+O3)

Text following text between *** is cut and paste from the XL sheet

***

Team Name "Starting
km" "Finishing
km" Total km "Penalty Points
Official Distance 117km
1 penalty point for
Each km over/under" Start Time Finish Time Total Time "Penalty Points
Official Length 175 minutes
(2h 55m)
1 pt p/m if late
2 pts p/m if early" Panics opened Penalties Panics x10 "Wrong side of
Envelope
opened" Penalties Envelope x10 "Incorrect/Incomplete
Puzzles" Penalties Puzzles x3 Totals
Dancer 28502 28642 =SUM(C3-B3) =IF(D3=0,0,ABS(D3-117))
0.736805555555556 0.881944444444445 =SUM(G3-F3)*24*60
=IF(H3=0,0,IF(H3<175,(((175-H3)*2)/1440),IF(H3175,((H3-175)/
1440),IF(H3=175,0)))) 1 =SUM(J3*10) 4 =SUM(L3*10) 0 =SUM(N3*3)
=SUM(E3+I3+K3+M3+O3)
***

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to create a calculated item based on a calculated field Stijn Excel Discussion (Misc queries) 1 August 25th 08 05:30 PM
Calculated Field and Calculated Item in Pivot Table Fred Smith Excel Discussion (Misc queries) 0 March 4th 07 08:15 PM
PivotTable:Using a calculated field result in another calculated f Alice Excel Worksheet Functions 0 June 8th 06 05:21 PM
pivot table formulas for calculated field or calculated item Vicky Excel Discussion (Misc queries) 3 June 6th 06 05:06 AM


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"