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

dividing time
 

That is because time is stored as a decimal of a 24 hour day. You can
either format your result as time or multiply it by (24*60 = 1440 minutes in
a day)

demo'd from the immediate window.

? (timevalue("0:10:30")/60)*1440
0.175

--
Regards,
Tom Ogilvy


"jhahes" wrote in
message ...

how do you do the following.


if i have a time or amount of time of (10 minutes 30 seconds). How do I
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 5
zeros before a positive number. The result I am looking for is


10.5 / 60

= .1750

thanks for any help

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile:
http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=473462