Counting the minutes worked on multiple days

Sicuu

New Member
Joined
Jan 5, 2018
Messages
4


Hi,

Please help me with counting the minutes worked on multiple days.

For example, on 1-Oct I worked 2 tasks, each one of them have different counting system, that's colon C for(it's a drop list witch is telling me what i did).
What i want is excel to calculate how many minutes I've worked today, tomorrow and so on. I can't find a way to calculate it separately.

Thank you.
fGU7bc
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
You can use a pivot table on the data to sum by day or use SUMIF.

Code:
SUMIF(range, criteria, sum range

Code:
=SUMIF(A:A, the date you seek, J:J)

Feel free to adjust the ranges accordingly. Or if this won't do, let me know.
 
Upvote 0
With pivot tables I can't work, I don't know how yet and I haven't heard about sumif untill now. I'll try both options and I'll see what I can do.
Thank you!
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,286
Members
452,631
Latest member
a_potato

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