LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Rob is offline
external usenet poster
 
Posts: 234
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Revenue divided by Day How? Qazi Ahmad Excel Discussion (Misc queries) 4 April 18th 07 07:10 AM
365-day divided into 13 periods helen Excel Discussion (Misc queries) 7 October 24th 06 04:13 PM
returning zero on pct divided by zero dave99 Excel Discussion (Misc queries) 2 January 7th 06 08:47 PM
Why are my cell being divided by 100? Bill Excel Worksheet Functions 2 June 15th 05 10:06 PM
Numbers divided by 100 Janepige Excel Discussion (Misc queries) 3 January 5th 05 09:55 AM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"