Thread: dividing time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jhahes[_36_] jhahes[_36_] is offline
external usenet poster
 
Posts: 1
Default dividing time


how do you do the following.


if i have a time or amount of time of (10 minutes 30 seconds). How do
divide that number or amount of time by 1 hour (60 minutes 0 seconds).
to get a decimal.

Right now when i try the above situation i get a number with about
zeros before a positive number. The result I am looking for is


10.5 / 60

= .1750

thanks for any help

Jos

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=47346