Spreadsheet: 797535d1663944962-help-sumifs-formula-with-date-range-and-text-exported_hours-7-
Sheet: Exported_Hours - Data List

Owner | Hour Type | Status | Date | Hours | Actual Cost | Revenue | Notes
[NAME] | Task Time | Approved | 2022-08-16 00:00:00 | 0.5 | 0 | 54 | TLI WF setup review meeting with [NAME] and [NAME]
[NAME] | Task Time | Approved | 2022-08-17 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-18 00:00:00 | 0.5 | 0 | 54 | [NAME]
[NAME] | Task Time | Approved | 2022-08-22 00:00:00 | 0.5 | 0 | 54 | Weekly Resource Email.
[NAME] | Task Time | Approved | 2022-08-23 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-25 00:00:00 | 4 | 0 | 432 | TLI Status(s) POD 3 Meeting TLI WF Clean up
[NAME] | Task Time | Approved | 2022-08-26 00:00:00 | 2 | 0 | 216 | TLI WF Clean up Meeting with [NAME]
[NAME] | Task Time | Approved | 2022-08-29 00:00:00 | 3 | 0 | 324
[NAME] | Task Time | Approved | 2022-08-30 00:00:00 | 1.5 | 0 | 162
[NAME] | Task Time | Approved | 2022-08-31 00:00:00 | 2.5 | 0 | 270 | Pod 3 Midyear account review
[NAME] | Task Time | Approved | 2022-09-01 00:00:00 | 1.5 | 0 | 162 | [NAME] Internal Status
[NAME] | Task Time | Approved | 2022-09-02 00:00:00 | 1.5 | 0 | 162
[NAME] | Task Time | Approved | 2022-09-06 00:00:00 | 3 | 0 | 324 | Resourcing Email Weekly 1-on-1 Timeline updates and Asset Reorg
[NAME] | Task Time | Approved | 2022-09-06 00:00:00 | 1 | 0 | 108 | TLI Strategy Check-on
[NAME] | Task Time | Approved | 2022-09-07 00:00:00 | 0.5 | 0 | 54 | TLI Interim Project Deliverable Compilation and Prep for Client
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 54 | [NAME]
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 54 | Internal Status
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 2.5 | 0 | 270 | Process audit and improvement Blog Review Writers briefing emails
[NAME] | Task Time | Approved | 2022-09-09 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-12 00:00:00 | 0.5 | 0 | 54
[NAME] | Task Time | Approved | 2022-09-14 00:00:00 | 2.5 | 0 | 270
[NAME] | Task Time | Approved | 2022-09-13 00:00:00 | 4 | 0 | 432 | TLI Purpose Campaign initial planning
[NAME] | Task Time | Approved | 2022-09-13 00:00:00 | 0.5 | 0 | 54
[NAME] | Task Time | Approved | 2022-09-12 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-13 00:00:00 | 0.75 | 0 | 81 | 1-on-1 audrey
[NAME] | Task Time | Approved | 2022-09-12 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 1 | 0 | 108 | Internal Status Prep
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 2 | 0 | 216 | Weely TLI Status Kyle/Alexis Purpose Campaign Planning
[NAME] | Task Time | Approved | 2022-09-14 00:00:00 | 0.5 | 0 | 54 | October Social Media Assets Kickoff
[NAME] | Task Time | Approved | 2022-09-16 00:00:00 | 1 | 0 | 108 | Pod 3 Resourcing [NAME]
[NAME] | Task Time | Submitted | 2022-09-22 00:00:00 | 1 | 0 | 108 | Internal Status Paid Media [NAME]
[NAME] | Task Time | Submitted | 2022-09-22 00:00:00 | 1 | 0 | 108 | [NAME] TLI Check w/Alexis
[NAME] | Task Time | Submitted | 2022-09-21 00:00:00 | 2.25 | 0 | 243 | Presentation Support
[NAME] | Task Time | Submitted | 2022-09-21 00:00:00 | 0.75 | 0 | 81 | Meetings with [NAME] to finish deck
[NAME] | Task Time | Submitted | 2022-09-21 00:00:00 | 1 | 0 | 108 | Meeting with Alexis for Presentation Support
[NAME] | Task Time | Submitted | 2022-09-22 00:00:00 | 1.5 | 0 | 202.5 | Paid Media kickoff, Client Status Call, Internal Status call (each 30 mins)
[NAME] | Task Time | Submitted | 2022-09-21 00:00:00 | 0.5 | 0 | 67.5 | client call with [NAME] and [NAME]
[NAME] | Task Time | Approved | 2022-08-15 00:00:00 | 1 | 0 | 105 | communicating with Emily about leanne's client data request
[NAME] | Task Time | Approved | 2022-08-09 00:00:00 | 4 | 0 | 420 | July first look report; ask Emily questions
[NAME] | Task Time | Approved | 2022-08-10 00:00:00 | 4 | 0 | 420 | July first look report
[NAME] | Task Time | Approved | 2022-08-08 00:00:00 | 0.5 | 0 | 52.5 | check in with Emily
[NAME] | Task Time | Approved | 2022-08-31 00:00:00 | 0.25 | 0 | 26.25 | media emails
[NAME] | Task Time | Approved | 2022-08-17 00:00:00 | 0.75 | 0 | 101.25 | TLI Purple Paper design kickoff **post prep - packaging wealth Purple Paper files for template
[NAME] | Task Time | Approved | 2022-08-18 00:00:00 | 0.5 | 0 | 67.5 | ADA meeting with KW (Purple Paper Prep)
[NAME] | Task Time | Approved | 2022-07-22 00:00:00 | 1 | 0 | 211.5
[NAME] | Task Time | Approved | 2022-08-04 00:00:00 | 0.5 | 0 | 105.75
[NAME] | Task Time | Approved | 2022-08-11 00:00:00 | 0.5 | 0 | 105.75
[NAME] | Task Time | Approved | 2022-08-12 00:00:00 | 1.5 | 0 | 317.25 | Internal team meeting to talk about timing/next steps; onboarding/greeting meeting with [NAME]
[NAME] | Task Time | Approved | 2022-08-15 00:00:00 | 0.75 | 0 | 158.625 | Leadership survey topline meeting
[NAME] | Task Time | Approved | 2022-08-16 00:00:00 | 0.5 | 0 | 105.75 | Deck review
[NAME] | Task Time | Approved | 2022-08-17 00:00:00 | 0.5 | 0 | 105.75 | Purple paper design kickoff
[NAME] | Task Time | Approved | 2022-08-18 00:00:00 | 2.5 | 0 | 528.75 | Client call (.5); 2.5 (edit plan development - 1 hr brainstorm with Britta, 1 hour documentation)
[NAME] | Task Time | Approved | 2022-09-01 00:00:00 | 1 | 0 | 211.5 | .5 [NAME], .5 internal meeting
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 105.75 | Weekly team meeting
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 105.75 | Client call
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 0.5 | 0 | 105.75 | Client status
[NAME] | Task Time | Approved | 2022-07-22 00:00:00 | 0.5 | 0 | 105.75 | meeting with [NAME], Leanne and company on new TLI ask (wasn't sure exactly where to put the time)
[NAME] | Task Time | Approved | 2022-08-24 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-25 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-22 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-23 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-26 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-29 00:00:00 | 2 | 0 | 432
[NAME] | Task Time | Approved | 2022-08-30 00:00:00 | 2 | 0 | 432
[NAME] | Task Time | Approved | 2022-08-31 00:00:00 | 2 | 0 | 432
[NAME] | Task Time | Approved | 2022-09-01 00:00:00 | 2 | 0 | 432
[NAME] | Task Time | Approved | 2022-09-02 00:00:00 | 1 | 0 | 216
[NAME] | Task Time | Approved | 2022-09-09 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-06 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-12 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-13 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-14 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-16 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-12 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-05-27 00:00:00 | 0.2 | 0 | 60 | invoicing with FP&A
[NAME] | Task Time | Approved | 2022-06-01 00:00:00 | 0.5 | 0 | 150 | meeting notes and action items reviewed
[NAME] | Task Time | Approved | 2022-06-07 00:00:00 | 0.75 | 0 | 225 | 1:1 with Leanne on timing and process for strategy..gathering and hearing feedback from bill rogers interview and dontá for insights on business plan
[NAME] | Task Time | Approved | 2022-06-09 00:00:00 | 1 | 0 | 300 | contractor resourcing for strategy with leanne
[NAME] | Task Time | Approved | 2022-06-10 00:00:00 | 0.6 | 0 | 180 | senior strategist HR work to get work on schedule due to interview delays
[NAME] | Task Time | Approved | 2022-06-14 00:00:00 | 0.5 | 0 | 150 | resourcing for strategy in july
[NAME] | Task Time | Approved | 2022-06-15 00:00:00 | 0.25 | 0 | 75 | contractor approval for strategy.
[NAME] | Task Time | Approved | 2022-06-24 00:00:00 | 0.5 | 0 | 150
[NAME] | Task Time | Approved | 2022-08-04 00:00:00 | 0.5 | 0 | 150 | strategy regroup and resouring plan for [NAME] to support Q3/Q4 push
[NAME] | Task Time | Approved | 2022-08-08 00:00:00 | 1 | 0 | 300 | 1:1 with Leanne on resourcing, quick-turn ask and strategy needs for [NAME] with [NAME]
[NAME] | Task Time | Approved | 2022-08-12 00:00:00 | 0.5 | 0 | 150 | partial 1:1 with [NAME] for [NAME] and ad hoc projects
[NAME] | Task Time | Approved | 2022-08-17 00:00:00 | 0.4 | 0 | 120 | [NAME] training/[NAME] chat
[NAME] | Task Time | Approved | 2022-08-19 00:00:00 | 0.5 | 0 | 150 | forecasting regroup
[NAME] | Task Time | Approved | 2022-08-23 00:00:00 | 0.75 | 0 | 225 | regroup with Leane
[NAME] | Task Time | Approved | 2022-08-22 00:00:00 | 0.75 | 0 | 225 | leanne strategy review
[NAME] | Task Time | Approved | 2022-08-26 00:00:00 | 0.25 | 0 | 75 | partial august month end finance meeting to reconcile
[NAME] | Task Time | Approved | 2022-08-29 00:00:00 | 1 | 0 | 300 | training
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 1 | 0 | 300 | strategy support with leanne/[NAME]
[NAME] | Task Time | Submitted | 2022-09-22 00:00:00 | 0.5 | 0 | 150
[NAME] | Task Time | Approved | 2022-05-19 00:00:00 | 0.5 | 0 | 117
[NAME] | Task Time | Approved | 2022-05-26 00:00:00 | 0.5 | 0 | 117
[NAME] | Task Time | Approved | 2022-06-09 00:00:00 | 0.5 | 0 | 117
[NAME] | Task Time | Approved | 2022-08-12 00:00:00 | 1 | 0 | 234 | work as task named .... internal kickoff meeting for TLI interim
[NAME] | Task Time | Approved | 2022-09-01 00:00:00 | 1 | 0 | 234
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 1.5 | 0 | 351
[NAME] | Task Time | Approved | 2022-05-02 00:00:00 | 1 | 0 | 290
[NAME] | Task Time | Approved | 2022-05-03 00:00:00 | 3 | 0 | 870
[NAME] | Task Time | Approved | 2022-05-05 00:00:00 | 1 | 0 | 290
[NAME] | Task Time | Approved | 2022-05-16 00:00:00 | 4 | 0 | 1160
[NAME] | Task Time | Approved | 2022-05-17 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-05-18 00:00:00 | 1.5 | 0 | 435
[NAME] | Task Time | Approved | 2022-05-19 00:00:00 | 1 | 0 | 290
[NAME] | Task Time | Approved | 2022-06-21 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-06-22 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-06-23 00:00:00 | 1.5 | 0 | 435
[NAME] | Task Time | Approved | 2022-07-05 00:00:00 | 1.5 | 0 | 435
[NAME] | Task Time | Approved | 2022-07-06 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-07-07 00:00:00 | 1.5 | 0 | 435
[NAME] | Task Time | Approved | 2022-07-08 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-08-29 00:00:00 | 1 | 0 | 290
[NAME] | Task Time | Approved | 2022-08-30 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-08-31 00:00:00 | 1.5 | 0 | 435
[NAME] | Task Time | Approved | 2022-05-03 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-02 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-05 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-09 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-10 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-11 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-12 00:00:00 | 1 | 0 | 135
[NAME] | Task Time | Approved | 2022-05-17 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-18 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-19 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-20 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-23 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-24 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-25 00:00:00 | 1 | 0 | 135
[NAME] | Task Time | Approved | 2022-05-26 00:00:00 | 1.5 | 0 | 202.5
[NAME] | Task Time | Approved | 2022-05-27 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-06-01 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-06-02 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-06-13 00:00:00 | 1 | 0 | 135
[NAME] | Task Time | Approved | 2022-06-14 00:00:00 | 1 | 0 | 135 | Actual + Planned vs Budget reconciliation in Workfront on T&M programs
[NAME] | Task Time | Approved | 2022-06-15 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-06-16 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-06-17 00:00:00 | 0.75 | 0 | 101.25
[NAME] | Task Time | Approved | 2022-06-23 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-07-01 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-07 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-08 00:00:00 | 1 | 0 | 135
[NAME] | Task Time | Approved | 2022-07-12 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-13 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-15 00:00:00 | 2 | 0 | 270
[NAME] | Task Time | Approved | 2022-07-22 00:00:00 | 2 | 0 | 270
[NAME] | Task Time | Approved | 2022-07-21 00:00:00 | 2.5 | 0 | 337.5
[NAME] | Task Time | Approved | 2022-07-20 00:00:00 | 1 | 0 | 135
[NAME] | Task Time | Approved | 2022-07-26 00:00:00 | 0.75 | 0 | 101.25
[NAME] | Task Time | Approved | 2022-07-25 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-27 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-29 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-28 00:00:00 | 0.75 | 0 | 101.25
[NAME] | Task Time | Approved | 2022-08-05 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-08-02 00:00:00 | 2 | 0 | 270
[NAME] | Task Time | Approved | 2022-08-03 00:00:00 | 2.5 | 0 | 337.5
[NAME] | Task Time | Approved | 2022-08-04 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-10 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-11 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-15 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-08-16 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-17 00:00:00 | 0.5 | 0 | 67.5 | PT work with [NAME] and [NAME] for Interim work
[NAME] | Task Time | Approved | 2022-08-18 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-19 00:00:00 | 0.5 | 0 | 67.5
Keats Pierce | Task Time | Approved | 2022-08-18 00:00:00 | 1 | 0 | 211.5