View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Rob is offline
external usenet poster
 
Posts: 234
Default Value divided by time

Thanks, just the job.

Rob

"Bob Phillips" wrote in message
...
=value/(time*24*60)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Rob" wrote in message
...
Hi,

I have a spreadsheet that contains time in one column and a value in
another eg. time is 00:00:24 and value is .07

I want to find out how much I'm charged per minute and dividing the value
by time isn't looking correct. I guess I need to convert time to a
number but can't figure out.

Thanks, Rob