Shows the round trip time of a given host. This function is available via the taskpane as well as directly via the cell “=PINGTIME(…)”

Return Value

When the pinged host is down, the function returns “DOWN”. When the pinged host is up, the function returns the round trip time (RTT) in milliseconds, if the round trip time is below 1 millisecond, the function will return “<1 ms”. Adding the unit can be disabled in the settings panel.


host – Specifies the host you want to ping, can be both a hostname or IPv4 address.

timeout – Specifies the amount of time in milliseconds to wait for the reply message, must be an integer between 1 and 4000.

attempts – Specifies the number of requests sent, must be an integer between 1 and 10.


Excel round trip time using the Network Tools For Excel PINGTIME formula

Instructional Video