Time Duration

		Microsoft Office Forums > Microsoft Excel > Excel
Time Duration

FAQ

Thread Tools

Display Modes

11-25-2014, 09:48 AM

cangelis

Windows 7 64bit Time Duration

Office 2010 64bit

Novice

Join Date: Jan 2014

Posts: 18

Time Duration

I need help please. I need to calculate a column of data reflecting time duration. The buckets I need are 0 <=8, 8 <=16, 16 <= 24

My data is in one column and may be a duration of 0:47:08 , or 1:17:24 , etc.

So, essentially the calculation would be 0 hrs to <=8 hrs

I would then create a pivot table to sum or count each of those values per day. For example, out of 2000 jobs 345 would be between 0-8 hours, 444 between 8 and 16 hours, etc.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
date & time of last time a recent file was used	pgeorgilas	Word	1	10-31-2014 08:59 AM
Time allotted minus time used with result in hour and minute	esther6086	Excel	2	04-29-2014 05:03 PM
Project Duration for Part Time Resources	Kingrollo	Project	5	11-20-2012 06:44 AM
Change Resource Time vs. Duration when Updating Work column	lylel	Project	3	07-23-2012 06:09 PM
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in	tinfanide	Excel Programming	1	03-04-2012 12:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:09 PM.