Total working hours per month and year

[capriconuser]

I have data in excel .. kindly check attached sheet.. there is fromtime and totime and working hours columns

i want total working hours worked per month and per year..

any one can tell how i do that ?

[jayshrinipurte]

Hi,

Can you please elaborate your question as you can easily calculate monthly and yearly hours  from the difference 

Regards, 

Jayshri

[alex00321 · Accepted solution]

Hi Please check attached file to see if this works. Thanks!

[capriconuser]

@alex00321 

if i select Nov 2018 then this shows me 156:65 

and i am extracting data from zoho .. so in zoho total hours are different 

[alex00321]

Hi I'm using below formula to check year:

Year(Date(UpdatedDate,'MM/DD/YYYY')) as YeartoFilter,

And I also use it to grab month. Then I got below

Not sure how you get your number. Thanks!