Calculating Contacts per hour

[Darrell Catmull]

I am tracking how many phone calls I make per hour. The cell for hours is
in [h]:mm format and the formula divides the time by the total number of
peole I contact. I seem to be having a conflict e.g. numbers and time.

The formula Im using is =IF(D10<>"",D10/D4,"") where D10 is the number of
people and D4 is the time spent.

Do you know of a solution or should I track my time (D4) in "Number" Format
instead of "[h]:mm" Format?

--
Thank you for your time
Darrell
Salt Lake City, Utah
800-720-1150

[Chip Pearson]

Times are stored as a fraction of a 24 hour day, regardless of how you have
the cell formatted. Multiply the time by 24 hour before using it in
calculation.

=D10/(D4*24)

For lots more information about working with dates and times in Excel, see
the Dates And Times pages on my web site, starting at
www.cpearson.com/excel/datetime.htm

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting Services
www.cpearson.com ch...@cpearson.com

"Darrell Catmull" <cat...@wfrmls.com> wrote in message
news:Pitj4.662$a4.3...@news.uswest.net...