View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
karthik karthik is offline
external usenet poster
 
Posts: 48
Default Calculate Items Per Hour

Hi,
I've items Produced in Column A and the time taken to produce in Column B, I
would like to know if there is a way to calculate number of items produced in
an hour.
Data looks like this.

A B
15 0:02:01
20 0:03:36
169 0:15:45
742 1:08:55
535 0:15:56
52 0:03:14

Time is in HH:MM:SS format.
Thanks for your help in advance.

--
Karthi