Hi

I really need some help with my problem's. I will try to keep i
simple.

2006-01-26 18:05:07 0
2006-01-26 20:10:06 1
2006-01-27 06:16:46 0
2006-01-27 07:17:29 1
2006-01-30 20:41:35 0
2006-01-30 23:30:43 1
2006-01-31 14:10:57 0

I have that in an excel file. 1 mean the thing's is open, 0 mean th
thing's is not. We can see that there is not a values for each days. I
another sheet, i have (in this case) all day 2006 january

2006-01-01
2006-01-02
2006-01-03
2006-01-04
2006-01-05
2006-01-06
2006-01-07
2006-01-08
2006-01-09
2006-01-10
2006-01-11
2006-01-12
2006-01-13
2006-01-14
2006-01-15
2006-01-16
2006-01-17
2006-01-18
2006-01-19
2006-01-20
2006-01-21
2006-01-22
2006-01-23
2006-01-24
2006-01-25
2006-01-26
2006-01-27
2006-01-28
2006-01-29
2006-01-30
2006-01-31

Like this. I would like to past in that sheet the amount of time i
minutes that the thing have been open. Example : 2006-01-27 07:17:29
1
2006-01-30 20:41:35
0
That mean's the thing have been open for 3 days, but i need a macr
that will put for january 28, 1440 minutes, and january 29, 144
minutes, and all the minutes for the other days!! Which you guy
understand me :P! Ask some clarifications if needed :P!
Thanks you

--
mha
-----------------------------------------------------------------------
mhax's Profile: http://www.excelforum.com/member.php...fo&userid=3645
View this thread: http://www.excelforum.com/showthread.php?threadid=56212