Value divided by time
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 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 |
Value divided by time
=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 |
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 |
All times are GMT +1. The time now is 12:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com