Value divided by time

[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

 

[Mike H]

Rob,

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

Mike

 

[Bob Phillips]

=value/(time*24*60)

--
HTH

Bob

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

 

[Rob]

Thanks, just the job.

Rob

=value/(time*24*60)

--
HTH

Bob

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