PDA

View Full Version : [SOLVED] time utilization



salih129
09-25-2013, 06:06 PM
With the data attached, I would like to find the time used for each day, in hours. For example, for the first row, since it starts on 4 jan 11:00 and ends on 5 jan at 12:00, the data that I would need to says that 13 hours were used on 4 jan and 12 hours on 5 jan. Please take note that some of the days overlap also. So i would need a summation of the time utilized. Thanks. start end1/4/13 11:00 1/5/13 12:001/6/13 3:00 1/6/13 14:001/6/13 15:00 1/7/13 4:001/7/13 9:00 1/7/13 22:001/8/13 6:00 1/8/13 22:001/9/13 12:00 1/10/13 1:001/10/13 9:00 1/10/13 17:001/14/13 8:00 1/15/13 6:001/16/13 18:00 1/17/13 10:00

p45cal
09-26-2013, 01:24 AM
See attached.
There is probably a slicker solution.
For others, those dates as numbers (because of international date format differences) in a more useable arrangement for copy/pasting (text-to-columns with a space delimiter and format as date after copying):

start end
41278.45833 41279.5
41280.125 41280.58333
41280.625 41281.16667
41281.375 41281.91667
41282.25 41282.91667
41283.5 41284.04167
41284.375 41284.70833
41288.33333 41289.25
41290.75 41291.41667

salih129
10-08-2013, 10:13 PM
Thanks a lot for the help. Appreciate it.