Mac Forum / Applications / Excel / July 2009

timyk@officeformac.com wrote on 2009-07-03 15:40:

For Excel, a day has a value of 1. Therefore, an hour actually equals 1/24,
a minute is 1/(24*60), and a second is worth 1/(24*60*60). Therefore,
although a cell would display 12:00:00, the real value used for calculations
is 0.5.

So for example if you enter 0:2:30 (meaning 2 minutes 30 seconds) in a cell,
multiply by 86400 to get 150 seconds in your calculations.

JL
Mac OS X 10.4.11
Office v.X 10.1.9, Office 2008 12.1.latest

Hi,

Since the common measurement of speed in the metric system would be in Km/Hr
or M/Sec your formulas would be, assuming the time is in A1 and the distance
in A2

=A2/A1/24  Km/Hr

=A2*1000/(A1*24*60*60)   m/s

the second one simplifies to

=A2/(A1*86.4)

Remember to format these as numbers.

Thanks for the info. I didn't know that Excel treated a day as 1. This really simplifies what I was trying to do. Thanks again

Tim

The others definitely have you on the right track so this is probably
redundant, but one thing that helped me get this straight a number of years
ago is the realization that Time is time of the day, whereas periods of time
[years, months, weeks, hours, minutes & seconds] are units of measurement.