Value divided by time

R

Rob

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
 
B

Bob Phillips

=value/(time*24*60)

--
HTH

Bob

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