Function Dates Times Class

ShipBells

Returns the number of ships bells to be rung at the given time, or zero for none. Ships rings their bells at half-hour intervals. For all other times, this function returns 0 (zero).

Signature (Visual Basic / VBA)

Public Function ShipBells( _
    ByVal vTime As Variant _
    ) As Variant

Code Example

    ShipBells(#7:30:00 AM#) = 7
    ShipBells(#3:30:00 PM#) = 7
    ShipBells(#9:00:23 PM#) = 2
    ShipBells(#9:01:00 PM#) = 0

Parameters

Parameter Description
vTime Number whose time component is used to determine the number of ships bells to be rung. Function returns Null if vTime is Null or cannot be fixed up to a number. The time component of vTime is rounded to the nearest minute.