adding cells with text

[smokiibear]

I use my outlook calander as a time sheet for projects I work on. I then take the duration of the events and add them up for billing my clients.

I'm curios if anyone knows how to automate adding up the duration of selected events in order to make this process a little less painful. I usually add up around 200-300 events every month.

To make things slightly simpler, I copy the event from outlook directly into excel. One of the columns is duration, which specified a number with a unit - either # minutes or # hours. Is there a routine, vba or other, than I could implement to add up that column and convert it to hours? I don't mind a little manualness to the convention, but looking for a way to skip manually entering the colum in purely numbers in order to compute the total duration.

Hope this makes sense. i can provide more information or files if that would be helpful.

Thanks in advance!!!

 

[joeu2004]

I use my outlook calander as a time sheet for projects I work on.
[....] I copy the event from outlook directly into excel.
One of the columns is duration, which specified a number with a
unit - either # minutes or # hours. Is there a routine, vba or
other, than I could implement to add up that column and convert
it to hours? I don't mind a little manualness

I am not familiar with the form of the data, since I do not use Outlook
Calendar. If you posted some concrete examples, I might be more helpful.

If the data looks like "59 min" and "1.23 hr" -- notably, a space after the
number -- I would use the Text To Data operation to separate the text into
two columns. If necessary, I would paste into Notepad first, then copy and
paste into Excel. Sometimes that is necessary to avoid Excel's
"intelligent" interpretation of the copied object, which often just gets in
the way.

Once separated, the sum in hours might be calculated with the following
formula:

=SUMIF(B1:B300,"min",A1:A300)/60 + SUMIF(B1:B300,"hr",A1:A300)