Time subtotal incorrect

G

Glasgow Girl

New Member
Joined
Mar 9, 2016
Messages
24
I need to do a simple addition of column containing times. The cells are formatted [hh]:mm so no problem going over 24 hours. However calculation is out by a few minutes (total shows 91:09 but should be 91:15). I have checked that there are no random seconds in any cell. Just doesn't make sense. Can someone help? Thanks
 
Sort by date Sort by votes
Can you post an example that illustrates, with the times all formatted as [h]:mm:ss?
 
Upvote 0
shg said:
Can you post an example that illustrates, with the times all formatted as [h]:mm:ss?
Click to expand...
Sorry, can't upload spreadsheet, but this is what it looks like. The 'total' column should add up to 91hrs 15 mins not 91hrs 5mins.

Can you make any sense of this?

Thanks

[TABLE="class: MsoNormalTable, width: 524"]
<tbody>[TR]
[TD="width: 87"]
Date​
[/TD]
[TD="width: 48"]
Start​
[/TD]
[TD="width: 50"]
Finish​
[/TD]
[TD="width: 146"]
Venue​
[/TD]
[TD="width: 123"]
Employee​
[/TD]
[TD="width: 95"]
Shift START ​
[/TD]
[TD="width: 76"]
Shift END ​
[/TD]
[TD="width: 76"]
TOTAL ​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 18/04/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:30​
[/TD]
[TD="width: 146"]
VENUE 1​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:40​
[/TD]
[TD="width: 76"]
11:55​
[/TD]
[TD="width: 76"]
03:15:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 23/04/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
15:30​
[/TD]
[TD="width: 146"]
VENUE 2​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:18​
[/TD]
[TD="width: 76"]
15:55​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 24/04/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:30​
[/TD]
[TD="width: 146"]
VENUE 3​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:40​
[/TD]
[TD="width: 76"]
11:55​
[/TD]
[TD="width: 76"]
03:15:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 24/04/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
16:00​
[/TD]
[TD="width: 146"]
VENUE 4​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:10​
[/TD]
[TD="width: 76"]
16:25​
[/TD]
[TD="width: 76"]
03:15:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 25/04/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:00​
[/TD]
[TD="width: 146"]
VENUE 5​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:48​
[/TD]
[TD="width: 76"]
11:25​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 25/04/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
15:30​
[/TD]
[TD="width: 146"]
VENUE 6​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:18​
[/TD]
[TD="width: 76"]
15:55​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 26/04/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:30​
[/TD]
[TD="width: 146"]
VENUE 7​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:40​
[/TD]
[TD="width: 76"]
11:55​
[/TD]
[TD="width: 76"]
03:15:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 26/04/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
15:30​
[/TD]
[TD="width: 146"]
VENUE 8​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:18​
[/TD]
[TD="width: 76"]
15:55​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 30/04/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:00​
[/TD]
[TD="width: 146"]
VENUE 9​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:48​
[/TD]
[TD="width: 76"]
11:25​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 30/04/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
15:30​
[/TD]
[TD="width: 146"]
VENUE 10​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:18​
[/TD]
[TD="width: 76"]
15:55​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 01/05/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:30​
[/TD]
[TD="width: 146"]
VENUE 11​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:40​
[/TD]
[TD="width: 76"]
11:55​
[/TD]
[TD="width: 76"]
03:15:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 01/05/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
17:00​
[/TD]
[TD="width: 146"]
VENUE 12​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
12:55​
[/TD]
[TD="width: 76"]
17:25​
[/TD]
[TD="width: 76"]
04:30:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 03/05/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
15:30​
[/TD]
[TD="width: 146"]
VENUE 13​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:18​
[/TD]
[TD="width: 76"]
15:55​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 07/05/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:30​
[/TD]
[TD="width: 146"]
VENUE 14​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:40​
[/TD]
[TD="width: 76"]
11:55​
[/TD]
[TD="width: 76"]
03:15:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 07/05/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
17:00​
[/TD]
[TD="width: 146"]
VENUE 15​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
12:55​
[/TD]
[TD="width: 76"]
17:25​
[/TD]
[TD="width: 76"]
04:30:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 08/05/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
15:00​
[/TD]
[TD="width: 146"]
VENUE 16​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:25​
[/TD]
[TD="width: 76"]
15:25​
[/TD]
[TD="width: 76"]
02:00:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 09/05/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:00​
[/TD]
[TD="width: 146"]
VENUE 17​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:48​
[/TD]
[TD="width: 76"]
11:25​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 09/05/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
15:00​
[/TD]
[TD="width: 146"]
VENUE 18​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:25​
[/TD]
[TD="width: 76"]
15:25​
[/TD]
[TD="width: 76"]
02:00:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 10/05/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:00​
[/TD]
[TD="width: 146"]
VENUE 19​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:48​
[/TD]
[TD="width: 76"]
11:25​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 10/05/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
16:00​
[/TD]
[TD="width: 146"]
VENUE 20​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:10​
[/TD]
[TD="width: 76"]
16:25​
[/TD]
[TD="width: 76"]
03:15:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 13/05/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:30​
[/TD]
[TD="width: 146"]
VENUE 21​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:40​
[/TD]
[TD="width: 76"]
11:55​
[/TD]
[TD="width: 76"]
03:15:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 13/05/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
15:30​
[/TD]
[TD="width: 146"]
VENUE 22​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:18​
[/TD]
[TD="width: 76"]
15:55​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 14/05/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:30​
[/TD]
[TD="width: 146"]
VENUE 23​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:40​
[/TD]
[TD="width: 76"]
11:55​
[/TD]
[TD="width: 76"]
03:15:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 14/05/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
16:00​
[/TD]
[TD="width: 146"]
VENUE 24​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:10​
[/TD]
[TD="width: 76"]
16:25​
[/TD]
[TD="width: 76"]
03:15:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 15/05/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:30​
[/TD]
[TD="width: 146"]
VENUE 25​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:40​
[/TD]
[TD="width: 76"]
11:55​
[/TD]
[TD="width: 76"]
03:15:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 15/05/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
15:00​
[/TD]
[TD="width: 146"]
VENUE 26​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:25​
[/TD]
[TD="width: 76"]
15:25​
[/TD]
[TD="width: 76"]
02:00:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 16/05/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
12:30​
[/TD]
[TD="width: 146"]
VENUE 27​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:25​
[/TD]
[TD="width: 76"]
12:55​
[/TD]
[TD="width: 76"]
04:30:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 16/05/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
17:00​
[/TD]
[TD="width: 146"]
VENUE 28​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
12:55​
[/TD]
[TD="width: 76"]
17:25​
[/TD]
[TD="width: 76"]
04:30:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 17/05/2019[/TD]
[TD="width: 48"]
09:30​
[/TD]
[TD="width: 50"]
11:00​
[/TD]
[TD="width: 146"]
VENUE 29​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
08:48​
[/TD]
[TD="width: 76"]
11:25​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"] 17/05/2019[/TD]
[TD="width: 48"]
14:00​
[/TD]
[TD="width: 50"]
15:30​
[/TD]
[TD="width: 146"]
VENUE 30​
[/TD]
[TD="width: 123"]
MACPHERSON​
[/TD]
[TD="width: 95"]
13:18​
[/TD]
[TD="width: 76"]
15:55​
[/TD]
[TD="width: 76"]
02:37:00​
[/TD]
[/TR]
[TR]
[TD="width: 87"][/TD]
[TD="width: 48"][/TD]
[TD="width: 50"][/TD]
[TD="width: 146"][/TD]
[TD="width: 123"][/TD]
[TD="width: 95"][/TD]
[TD="width: 76"][/TD]
[TD="width: 76"][/TD]
[/TR]
[TR]
[TD="width: 87"][/TD]
[TD="width: 48"][/TD]
[TD="width: 50"][/TD]
[TD="width: 146"][/TD]
[TD="width: 123"][/TD]
[TD="width: 95"][/TD]
[TD="width: 76"]
Total​
[/TD]
[TD="width: 76"]
91:09​
[/TD]
[/TR]
</tbody>[/TABLE]
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-GB</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false" DefSemiHidden="false" DefQFormat="false" DefPriority="99" LatentStyleCount="371"> <w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 9"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="header"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footer"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index heading"/> <w:LsdException Locked="false" Priority="35" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="caption"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of figures"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope return"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="line number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="page number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of authorities"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="macro"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="toa heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 5"/> <w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Closing"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Signature"/> <w:LsdException Locked="false" Priority="1" SemiHidden="true" UnhideWhenUsed="true" Name="Default Paragraph Font"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Message Header"/> <w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Salutation"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Date"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Note Heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Block Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Hyperlink"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="FollowedHyperlink"/> <w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Document Map"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Plain Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="E-mail Signature"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Top of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Bottom of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal (Web)"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Acronym"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Cite"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Code"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Definition"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Keyboard"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Preformatted"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Sample"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Typewriter"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Variable"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Table"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation subject"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="No List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Contemporary"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Elegant"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Professional"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Balloon Text"/> <w:LsdException Locked="false" Priority="39" Name="Table Grid"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Theme"/> <w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" Name="Light List"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" SemiHidden="true" Name="Revision"/> <w:LsdException Locked="false" Priority="34" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" SemiHidden="true" UnhideWhenUsed="true" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/> <w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/> <w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/> <w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/> <w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/> <w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/> <w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 6"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman",serif;} </style> <![endif]-->
 
Upvote 0
91:09 is correct; why do you think it should be 91:15?
 
Upvote 0
If you add only the hours the result is 79 hours
If you add only the minutes, the result is 729 minutes
From 729 minutes you get the hours:
= 729/60 = 12.15
79 + 12 = 91
But .15 are not minutes, they correspond to .15 of an hour.
If you multiply .15 * 60 = 9 minutes

Result 91:09
 
Upvote 0
Hi
Thanks guys for taking the time to look at this.
I feel like an idiot! Totally get it now.
Sorry for the trouble but thanks for explaining
 
Upvote 0
Do not worry, it happens to us all the time. thanks for the feedback.
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question Question
enter time without colon
Replies
5
Views
359
etaf
etaf
R
  • Solved
Formatting time - minutes and seconds NOT time of day
Replies
2
Views
816
RodneyW
R
M
  • Question Question
Pivot table and calculation issues
Replies
1
Views
205
RoryA
RoryA
C
  • Solved
Sum for time on task calculations
Replies
3
Views
315
Asbestos_Jen
Asbestos_Jen
C
  • Solved
Calculate hour total for each week
2
Replies
16
Views
278
CaptainGravyBum
C

Forum statistics

Threads
1,226,837
Messages
6,193,249
Members
453,784
Latest member
Chandni

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top