Current time

[Simon]

Hi. Could someone plese tell me the function you enter to
disply the current time in a worksheet. Any help would be
appreciated. Thanks.

 

[Biff]

Hi Simon,

=NOW()

This will display both time and date. If you don't want
the date, then format the cell to display as you would
like.

Be aware that this is a volitale function and will change
each time the sheet calculates.

Biff