Calculating Total Hours from Range of Dates

[Matalyn]

Everyday, I will input the hours I spend on a specific task (range G:EE), the date I started working on the project (cell C4), and the date I finished it (cell D4). I want google spreadsheets to automatically calculate (within F4) the total number of hours I spent on the project between the start date and the end date.

What would the formula look like? I'm assuming its a form of the SUMIFS formula but not sure how to set it up?

Cell: A4=project employee is working on (range A4:AEE)-never ending
Cell: C4=Start Date
Cell: D4-Completion Date
Row 3 Columns G:EE is a 2014-2015 calendar of dates that are never ending
Cell: F4=Total Hours worked

 

[NeonRedSharpie]

G:EE is only 125 columns. Are there three rows? How is the data in those cells? Can there be more than one project in the cell? Any sample cells you can share?

 

[Matalyn]

https://docs.google.com/a/sgcmail.c...0Lrls2iTH65bWxWsDZyJeiZcXrBslMTLdY/edit#gid=0

Request to have access and I'll share the document with you!

Thanks.

 

[Matalyn]

To clarify: when I said EE, I meant like infinity but that was my bad because I forgot excel does actually have a column value of EE. hahaha

 

[Matalyn]

Were you able to click the link?
Here it is again just in case: https://docs.google.com/a/sgcmail.c...0Lrls2iTH65bWxWsDZyJeiZcXrBslMTLdY/edit#gid=0

 

[Matalyn]

You should have access now to that document.

In addition to my previous question, can you help me with this as well??:

I want all columns (within the calendar section of the excel doc.) to automatically hide if the date in Row 3 is 10 days prior to Todays date or more than 30 days after today's date. This way only 40 days will show at one time. Also, when I open the document, I want the calendar section to automatically go to todays date.

Is this possible?

Thanks!!

 

[Matalyn]

Did you get a change to look at this again?