I have a sheet werein there are columns one with time that marks the start of an event/activity of a person and the other with the event/activity. I want to calculate the total time of a particular activity and the number of time that activity was done. I can use the Countif to calculate the number of times but totally confused about how to calculate the total time of a particular activity as the time column only gives me the start time. For ex: 8:05 Start of Break 8:10 QC Start 8:15 Start of Break 8:20 Coaching 8:30 End of break 8:40 QC End
There might be multiple activities in between. So now how do I calculate the total time between different activities and then summing total time for particular activity etc. Is there a solution/formula/macro anything or do I have to do it manually by removing the difference between every activities and then adding the totals? Please advise.
Hi shailesh and welcome to the Forum.
..Looks like to need a SUMIF function, but for berret answers, would you like to upload a sample workbook??
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
sorry had to get the raw file...could any one help me with this please either a formula, pivot or vba anything
Last edited by shailesh; 01-13-2012 at 10:28 PM.
Hi shailesh
Try thisIt shows the time difference in hours & minutes=MOD(D11-C11,60)
Have Fun
Thank you Philb, but do I have to do this manually every time the status is changed and then add up the sum total???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks