time function
Sorry but I don't get it...
"Mike H" wrote:
Hi,
Put your time range in 2 columns like this:-
Col D Col E
08:00 09:00
09:00 10:00
10:00 11:00
The put this formula in a cell and drag down
=SUMPRODUCT(--(A$1:A$100=D1)*(B$1:B$100))-(SUMPRODUCT(--(A$1:A$100E1)*(B$1:B$100)))
Mike
"catrrmg" wrote:
hi all. I've got the following situation: I have a column with operations and
a next one containg the time they occured (time format 00:00:00), what I want
is to determine a standart time interval for every occurence, eg: 08:15:12
should result 08:00 - 09:00 and so on, with 1 hour steps. I now I should
create a function and use the select statement but have no clue how to do
send the tim to the vba, process it and send it back to the cell. any help
will be much appreciated.
|