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

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

=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

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