ExcelBanter - Date and Time Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Date and Time Formula (https://www.excelbanter.com/excel-programming/288883-date-time-formula.html)

sryan[_2_]

Date and Time Formula

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

---
Message posted from http://www.ExcelForum.com/

Rob van Gelder[_4_]

Date and Time Formula

Sryan,

How about:
=NOW()-TODAY()

Rob

"sryan " wrote in message
...
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

---
Message posted from http://www.ExcelForum.com/

sryan[_3_]

Date and Time Formula

Thanks Rob.

Now() worked perfectly

---
Message posted from http://www.ExcelForum.com/

hassan

Date and Time Formula

=Time
-----Original Message-----
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

---
Message posted from http://www.ExcelForum.com/

.

All times are GMT +1. The time now is 03:33 AM.