Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Numeric functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - AverageSpeed function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Numeric - AverageSpeed

Syntax:
=AverageSpeed(Distance, Time)

Description:
Calculates the average speed when a distance was traveled in a particular time. The speed is returned in minutes per km or minutes per mile depending which unit of measure you use for distance.

Example:
Calculating the average speed when 10km was traveled in 52:30 minutes.
=AverageSpeed(10,"0:52:30")


litLIB