Date and Time Formula

[sryan]

Hi,

I can put in todays date using the formula:

=TODAY()

Is there any formaula like this that I can use for the time?

Any help with this would be greatly appreciated. Thanks

 

[Rob van Gelder]

Sryan,

How about:
=NOW()-TODAY()

Rob

 

[sryan]

Thanks Rob.

Now() worked perfectly

 

[hassan]

=Time