Calculations with time

[timyk]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

What formulas can I use to do calculations related to time?
ie: time is entered as hr:min:sec, distance entered as 00 in km or miles,
For example I would like to calculate speed, distance/time>
Could time be converted to a decimal format?

Thank you

 

[Laroche J]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

What formulas can I use to do calculations related to time?
ie: time is entered as hr:min:sec, distance entered as 00 in km or miles,
For example I would like to calculate speed, distance/time>
Could time be converted to a decimal format?

Thank you

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

 

[Shane Devenshire]

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.

 

[timyk]

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

 

[CyberTaz]

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.