LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
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
Dividing zero by zero Sanjeev Raghavan[_2_] Excel Worksheet Functions 4 March 1st 10 01:26 PM
Dividing a unit of time by a lump sum price sawahani Excel Discussion (Misc queries) 1 October 27th 09 07:38 PM
Dividing name kd Excel Worksheet Functions 1 April 19th 07 04:48 AM
Dividing Time guilbj2 Excel Discussion (Misc queries) 1 May 23rd 06 01:08 PM
Dividing a time span into shifts - overlapping days Heidi Excel Worksheet Functions 17 February 28th 06 01:40 AM


All times are GMT +1. The time now is 12:26 AM.

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"