IN
Upload

Loading...

You're viewing YouTube in English (US).
Switch to another language: | | | | | | | | | | View all
You're viewing YouTube in English.
Switch to another language: | | | | | | | | | | View all

Excel Magic Trick 379: Round to Nearest 1/10th Hour for Payroll

6,633

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Sep 4, 2009

See how to round the hours worked to the 1/10th of an hour using ROUND and MROUND functions. Learn about basic Time Calculations in Excel, also.

Loading...

  1. Excel Magic Trick 379: Round to Nearest 1/10th Hour for Payroll

  2. 2

    Excel Magic Trick 380: Negative Numbers Round To Nearest 5

  3. 3

    Excel Magic Trick 381: Merge Two Lists Tables w Advanced Filter and Remove Duplicates Feature

  4. 4

    Excel Magic Trick 382: Match Two Lists, Extract Column Data From Each List

  5. 5

    Excel Magic Trick 383:Conditional Formatting Between a Max and Min

  6. 6

    Excel Magic Trick 384: Keyboard Shortcut To Highlight 1000 Cells

  7. 7

    Excel Magic Trick 385: Generate Random Letters without RANDBETWEEN function

  8. 8

    Excel Magic Trick 386: Less Than the Letter M Conditional Formatting

  9. 9

    Excel Magic Trick 387: Data Validation Drop-Down List & Cell References

  10. 10

    Excel Magic Trick 388: Conditional Formatting and the Active Cell

  11. 11

    Excel Magic Trick 389: Ctrl + Period Keyboard Shortcut

  12. 12

    Excel Magic Trick 390: Increment Word & Number 2 Methods.

  13. 13

    Excel Magic Trick 391: Custom Number Format to Insert Symbol Automatically

  14. 14

    Excel Magic Trick 392: CHOOSE function Randomly Generate 1, 0 or Blank

  15. 15

    Excel Magic Trick 393: Remove Last Two Words From Column Of Data

  16. 16

    Excel Magic Trick #394: IF Function and Conditional Formatting

  17. 17

    Excel Magic Trick #395: When ROUND function Must Be Used

  18. 18

    Excel Magic Trick #396: COUNTIF function and Multiplying

  19. 19

    Excel Magic Trick #397: VLOOKUP Copied Down a Column (VLOOKUP Basics)

  20. 20

    Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values

  21. 21

    Excel Magic Trick 399: NA Error Trouble in Array Formula

  22. 22

    Excel Magic Trick 400: Show List of Values In Cells After Using Data Validation Drop-Down

  23. 23

    Excel Magic Trick 401: Quarterly Comparative Report - Pivot Table (PivotTable)

  24. 24

    Excel Magic Trick 402: Monthly Comparative Report - Pivot Table

  25. 25

    Excel Magic Trick 403: March End Quarterly Comparative Report - Pivot Table

  26. 26

    Excel Magic Trick 404: Quarterly Comparative Report SUMIFS function

  27. 27

    Excel Magic Trick 405: Quarterly Comparative Report SUMPRODUCT function

  28. 28

    Excel Magic Trick 406: Add 1 Extra For Each Deposit

  29. 29

    Excel Magic Trick 407: Amortization Table W Variable Rate

  30. 30

    Excel Magic Trick 408: VLOOKUP MIN Value

  31. 31

    Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record

  32. 32

    Excel Magic Trick 410: VLOOKUP: Convert Web Query Result 78.9k to 78,900

  33. 33

    Excel Magic Trick 411: Expandable Ranges In SUMIFS function.

  34. 34

    Excel Magic Trick 412: Data Validation Drop Down List & OFFSET function

  35. 35

    Excel Magic Trick 413: Copied Web Site Data Trouble CLEAN TRIM Text To Columns

  36. 36

    Excel Magic Trick 414: Retroactive Dynamic Ranges!

  37. 37

    Excel Magic Trick 415: Summarize Survey Results 2 Different Methods

  38. 38

    Excel Magic Trick 416: Add Invoices w Same Prefix (Number v Text problem examined)

  39. 39

    Excel Magic Trick 417: Get Last Value from Multiple Sheets

  40. 40

    Excel Magic Trick 418: Reference Every Third Value

  41. 41

    Excel Magic Trick 419: Add Two Largest, But Skip Columns C & E

  42. 42

    Excel Magic Trick 420: VLOOKUP w SUM function in 3rd argument (Football Betting Table)

  43. 43

    Excel Magic Trick 421: Conditional Formatting Row with MAX or MIN Value

  44. 44

    Excel Magic Trick 422: Conditional Formatting 1st Two Rows Regardless of Sort

  45. 45

    Excel Magic Trick 423: INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Function

  46. 46

    Excel Magic Trick 424: Conditional Formatting For Dynamic Range

  47. 47

    Excel Magic Trick 425: Functions That Can Handle Array Syntax And Do Not Require CSE

  48. 48

    Excel Magic Trick 426: VLOOKUP to Assign Category To A Sales Number

  49. 49

    Excel Magic Trick 427: Determine Day Name For Future Date

  50. 50

    Excel Magic Trick 428: Trouble Entering Dates - Date Syntax

  51. 51

    Excel Magic Trick 429: Count IDs that Are the Equivalent (DELTA function)

  52. 52

    Excel Magic Trick 430: Count Sales Numbers Greater Than Hurdle (GESTEP function)

  53. 53

    Excel Magic Trick 431: Excel 4 GET.CELL Macro Function

  54. 54

    Excel Magic Trick 432: Find & Extract Duplicate Records

  55. 55

    Excel Magic Trick 433: Custom Number Format for Showing Numbers Rounded to Thousands Position

  56. 56

    Excel Magic Trick 434: Extract Completed Records with Formula

  57. 57

    Excel Magic Trick 435: Extract Duplicate Records with Formula

  58. 58

    Excel Magic Trick 436: VLOOKUP W 4 Lookup Columns

  59. 59

    Excel Magic Trick 437: NETWORKDAYS Function for Counting Workdays

  60. 60

    Excel Magic Trick 465: Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculation

  61. 61

    Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.)

  62. 62

    Excel Magic Trick 439: NETWORKDAYS.INTL function Excel 2010

  63. 63

    Excel Magic Trick 440: Array Formulas Advanced Tips

  64. 64

    Excel Magic Trick 441: Count Times That Start With 7 (7:00, 7:15, etc.)

  65. 65

    Excel Magic Trick 442: Summarize Monthly Sales With Daily Transactional Dates - 5 Methods

  66. 66

    Excel Magic Trick 443: SUMIF Cumulative Sales Formula & Pivot Table Cumulative Sales Table

  67. 67

    Excel Magic Trick 444: Multiply Column Times Row With TRANSPOSE Function

  68. 68

    Excel Magic Trick 445: Complicated Criteria for MODE calculation LOOKUP

  69. 69

    Excel Magic Trick 446: Time In & Time Out in Same Cell Bad Setup Leads To Complicated Formula

  70. 70

    Excel Magic Trick 447: AND & OR functions For Advanced Filter Extract to New Sheet

  71. 71

    Excel Magic Trick 448: OFFSET Function To Avoid #REF! Error

  72. 72

    Excel Magic Trick 449: Excel Data Analysis Abbreviated Notes

  73. 73

    Excel Magic Trick 450: Number Formatting Abbreviated Notes (House Paint or Halloween Mask)

  74. 74

    Excel Magic Trick 451: Prefix Lookup & White and Greater Than 15 lbs Lookup

  75. 75

    Excel Magic Trick 452: IF Function Formula 16 Examples

  76. 76

    Excel Magic Trick 453: VLOOKUP for Commission Brackets Calculation (LOOKUP function also)

  77. 77

    Excel Magic Trick 454: Get Last Number or Word or Anything 4 Amazing LOOKUP functions

  78. 78

    Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Total

  79. 79

    Excel Magic Trick 456: Add Only Integer Part SUM & INT functions

  80. 80

    Excel Magic Trick 457: SUMPRODUCT & OR Criteria

  81. 81

    Excel Magic Trick 458: OR and AND criteria Together In Data Extract Array Formula Boolean Logic Math

  82. 82

    Excel Magic Trick 459: Non-Zero numbers = TRUE IF Function logical_test Argument Tricks

  83. 83

    Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functions

  84. 84

    Excel Magic Trick 461: Progress Toward Goal Chart or Thermometer Chart

  85. 85

    Excel Magic Trick 462:Show Formula Formula - Excel 4 Macro Function GET.CELL

  86. 86

    Excel Magic Trick 463: 4 ways to Add New Data To A Chart

  87. 87

    Excel Magic Trick 465: Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculation

  88. 88

    Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functions

  89. 89

    Excel Magic Trick 467: Conditional Formatting every Nth value (Conditional Format)

  90. 90

    Excel Magic Trick 468: Count Spaces at Beginning & End of Text String (Array Formula)

  91. 91

    Excel Magic Trick 469: VLOOKUP for Horsepower Calculation

  92. 92

    Excel Magic Trick 470: Formula For Days In Any Given Month

  93. 93

    Excel Magic Trick 471: Sort Horizontal With Formula 3 Examples

  94. 94

    Excel Magic Trick 472: Count Spaces at Beginning & End of Text String Simple Formula

  95. 95

    Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)

  96. 96

    Excel Magic Trick 474: Conditional Format At Every Change In Value

  97. 97

    Excel Magic Trick 475: SUMPRODUCT for Bank Deposit Calculation

  98. 98

    Excel Magic Trick 477: 13 Digit Number ID Shows Scientific Notation!?

  99. 99

    Excel Magic Trick 476: SUMPRODUCT Function for Weighted Average Cost From Transaction Data

  100. 100

    Excel Magic Trick 478: Reverse Two Way Lookup For Date and Time Column and Row Headers

  101. 101

    Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations

  102. 102

    Excel Magic Trick 480: Percentage Of Total - Formula or PivotTable (Pivot Table)

  103. 103

    Excel Magic Trick 481: Change Operator in Formula from Drop-Down Using CHOOSE function

  104. 104

    Excel Magic Trick 482: 2 Pivot Tables with Different Date Groupings On Same Sheet

  105. 105

    Excel Magic Trick 483:Sort sees Date Serial Numbers, Filter Sees Format or Serial Numbers

  106. 106

    Excel Magic Trick 484: Stop Automatic Copyright symbol ©

  107. 107

    Excel Magic Trick 485: Create Shorthand to speed up typing using AutoCorrect

  108. 108

    Excel Magic Trick 486: Avoid #DIV/0! Error in Formula 4 Examples (Divide By Zero Error)

  109. 109

    Excel Magic Trick 487: Hyperlink That Opens Different Workbook or Goes To Different Sheet

  110. 110

    Excel Magic Trick 488: VLOOKUP with 2 Lookup Values Return Table of Values & Track Down Errors

  111. 111

    Excel Magic Trick 490: Conditional Format for Budget Less Than $500.

  112. 112

    Excel Magic Trick 491: Count Matches in Individual Cells

  113. 113

    Excel Magic Trick 492: Count Matches in Single Cell

  114. 114

    Excel Magic Trick 493: Repeat a List of Names 7 times

  115. 115

    Excel Magic Trick 489: Extract Only Numbers From Text String Array Formula

  116. 116

    Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples)

  117. 117

    Excel Magic Trick #503: Custom Number Format For Turnover Ratio

  118. 118

    Excel Magic Trick #504: 3D Formatting For Cells Using Borders

  119. 119

    Excel Magic Trick #505: INDIRECT function 2-Way Lookup Date Trouble

  120. 120

    Excel Magic Trick #506: Summarize Data - Multiple Sheets & Banks Accounts - Checkbook Register

  121. 121

    Excel Magic Trick #507: Fix Bad Data So We Can Add With Two Criteria & Make Summary Report

  122. 122

    Excel Magic Trick 508: VLOOKUP with Dynamic Table using OFFSET function

  123. 123

    Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclature

  124. 124

    Excel Magic Trick 510: Amortization Table That Changes When Year Input Is Changed

  125. 125

    Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters

  126. 126

    Excel Magic Trick 512: Frugal Bargain Hunters - Series Discounts to Calculate Total Savings

  127. 127

    Excel Magic Trick 513: Equivalent Earnings Simple Formula

  128. 128

    Excel Magic Trick 514: Conditional Formatting Duplicate Values (3 Methods)

  129. 129

    Excel Magic Trick 515: Amortization Table Pay Off Early & Trouble Shoot Formula Creation

  130. 130

    Excel Magic Trick 516: Conditional Formatting Duplicates In Each Row COUNTIF & Mixed Cell References

  131. 131

    Excel Magic Trick 517: Vendor Name For Low Bid & % Cheaper Than Next Lowest Bid Formula

  132. 132

    Excel Magic Trick 518: Show Multiple Vendor Names Associated With Low Bid Array Formula INDEX

  133. 133

    Excel Magic Trick 519: SUBSTITUTE & REPLACE Functions

  134. 134

    Excel Magic Trick 520: FIND & SEARCH Functions

  135. 135

    Excel Magic Trick 521: Bankers Rounding (Half-Way-Even) vs. Arithmetic Rounding

  136. 136

    Excel Magic Trick 522: 30 Days In Each Month Calculations

  137. 137

    Excel Magic Trick 523: Fill In Blanks With Custom Number Formatted Number

  138. 138

    Excel Magic Trick 524: Extract Records Partial Text Not Criteria: 4 Methods

  139. 139

    Excel Magic Trick 525: Advanced Filter With Wild Cards

  140. 140

    Excel Magic Trick 526: Grading Pass / Fail or Letter Grade Formula IF, AND, VLOOKUP functions

  141. 141

    Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCH

  142. 142

    Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH and VLOOKUP functions

  143. 143

    Excel Magic Trick 529: Count Sales Over Last 7 Days For Given Product

  144. 144

    Excel Magic Trick 530: Does Text String Contain Repair OR Rework? OR SEARCH ISNUMBER functions

  145. 145

    Excel Magic Trick 531: Extract Numbers from Middle of Text String BB34G to 34 (2 methods)

  146. 146

    Excel Magic Trick 532: Count Blanks In Dynamic Range INDEX MATCH COUNTBLANK functions

  147. 147

    Excel Magic Trick 533: Date/Time Calculation excluding Holidays & Weekends

  148. 148

    Excel Magic Trick 534: Conditional Formatting for Weekends and Holidays

  149. 149

    Excel Magic Trick 536: List All Modes in Multimodal Data Set MODE.MULT Excel 2010 Function

  150. 150

    Excel Magic Trick 535: Count Weekdays Including Half Days NETWORKDAYS & NETWORKDAYS.INTL

  151. 151

    Excel Magic Trick 537: Drill Through Spreadsheets -- Formatting, Formulas, Editing

  152. 152

    Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through

  153. 153

    Excel Magic Trick 539: Extract New Records Not In Old List -- Filter Method

  154. 154

    Excel Magic Trick 540: Extract New Records Not In Old List - Array Formula Method

  155. 155

    Excel Magic Trick 541: Get Last Price In Column Based On Criteria In Other Columns

  156. 156

    Excel Magic Trick 542: PivotTable Count How Many Times A Word Occurs In Word Document

  157. 157

    Excel Magic Trick 543: Build Time Schedule With 15 Minute Intervals

  158. 158

    Excel Magic Trick 544: Conditional Formatting Row With Multiple Criteria In Other Columns

  159. 159

    Excel Magic Trick 545: Count Between Dates with 3 Criteria COUNTIFS & DCOUNTA & SUMPRODUCT

  160. 160

    Excel Magic Trick 546: Is Item List? Case Sensitive OR & EXACT functions

  161. 161

    Excel Magic Trick 547: Calculating Last Time File Was Accessed From Server Computer

  162. 162

    Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet

  163. 163

    Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature?

  164. 164

    Excel Magic Trick 550: Data Validation List Drop-Down Based On 2nd Data Validation List Dependent DV

  165. 165

    Excel Magic Trick 551: Count Mondays or Sundays or Tuesdays, etc. Between Start & End Date

  166. 166

    Excel Magic Trick 552: Display VLOOKUP Results Vertically

  167. 167

    Excel Magic Trick 553: SUMIF for Dollars and Euros

  168. 168

    Excel Magic Trick 554: Conditional Formatting for Weekends and Holidays Better than EMT 534

  169. 169

    Excel Magic Trick 555: IF & VLOOKUP Formula for Two Distinct Commission Calculations

  170. 170

    Excel Magic Trick 556: Change PivotTable Source Data (Pivot Table)

  171. 171

    Excel Magic Trick 557: CHOOSE function to lookup Formula or Function (2 Examples).

  172. 172

    Excel Magic Trick 558: VLOOKUP to verify if Whole Record is in Table

  173. 173

    Excel Magic Trick 559: Extract Nth Word In Text String

  174. 174

    Excel Magic Trick 560: Conditional Formatting Select OK, Column Numbers Get Font White

  175. 175

    Excel Magic Trick 561: Wildcards * and ?

  176. 176

    Excel Magic Trick 562: Extract Names - Some Names In List Have Middle Name Some Do Not

  177. 177

    Excel Magic Trick 563: WORKDAY.INTL & WORKDAY Excel 2010 Functions

  178. 178

    Excel Magic Trick 564: Daily Gantt Chart

  179. 179

    Excel Magic Trick 565: Excel 2010 Daily Gantt Chart

  180. 180

    Excel Magic Trick 566: Conditional Format A Chart Student Grades

  181. 181

    Excel Magic Trick 567: Collapsible Expandable Cell Ranges

  182. 182

    Excel Magic Trick 568: SUMIFS function Monthly Running Total from Transaction Data

  183. 183

    Excel Magic Trick 569: Extract Past Due Loans - Dynamic Formula

  184. 184

    Excel Magic Trick 570: Remove Duplicate Records Excel 2007 / 2010 Feature

  185. 185

    Excel Magic Trick 571: VLOOKUP To Create Form from Access Linked Data Import

  186. 186

    Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax

  187. 187

    Excel Magic Trick 573: VLOOKUP & OR functions For Filtering Data With Categories of Criteria

  188. 188

    Excel Magic Trick 574: Array Formula For Filtering Data With Categories of Criteria

  189. 189

    Excel Magic Trick 575: Conditional Formatting & Counting with 3 Criteria & Find Formula Mistakes

  190. 190

    Excel Magic Trick 576: Dynamic Break Even Chart using INDEX and MATCH functions

  191. 191

    Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records

  192. 192

    Excel Magic Trick 578: Formula To Grade Student Answer Where More Than One Possibility Exists

  193. 193

    Excel Magic Trick 565: Excel 2010 Daily Gantt Chart

  194. 194

    Excel Magic Trick 564: Daily Gantt Chart

  195. 195

    Excel Magic Trick 579: MOD function and Date Math Each Successive Date Is Repeated Twice

  196. 196

    Excel Magic Trick 580: Extract Digits To Right Of Decimal Into Individual Cells

  197. 197

    Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter

  198. 198

    Excel Magic Trick 582: Excel Errors 9 Types - What They Mean - How To Fix Them

  199. 199

    Excel Magic Trick 583: AVERAGEIF & IFERROR functions Mixed Cell References Gross Profit Percentage

  200. 200

    Excel Magic Trick 584: Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Names

Advertisement
to add this to Watch Later

Add to