View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Value divided by time

Rob,

What does ' a value' represent. 0.07 of what?

Mike

"Rob" wrote:

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