View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default Help! Converting minutes Need tomorrow



"nova" wrote:

Here is my problem. I need to do the following

A person made 89 calls. His average time per call was 01:31. I need a
formula that will tell me how many hours was spent on the phone converted
into hous and mins.

I'm sure there is a simple formula but I can not make it work. Can someone
help tonight?????