Showing current Time

Beckwa · Apr 25th, 2002, 10:26 AM

How do I get the time to be automatically added to my spreadsheet? Thanks for help, B

Ricky Morris · Apr 25th, 2002, 10:31 AM

Enter the following formula into a desired cell:

=now()

Format the cell as time by choosing Format > Cells from the menu. Click the Number tab, choose Time in the Category box, choose the desired time format in the Type box.

The time will be updated whenever the spreadsheet is recalculated.

Beckwa · Apr 25th, 2002, 10:36 AM

Thanks

B

Brian from Maui · Apr 25th, 2002, 10:36 AM

Try CTRL + SHIFT + :

Apr 25th, 2002, 10:31 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Enter the following formula into a desired cell: =now() Format the cell as time by choosing Format > Cells from the menu. Click the Number tab, choose Time in the Category box, choose the desired time format in the Type box. The time will be updated whenever the spreadsheet is recalculated. __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 10:26 AM	#1
Beckwa New Member Join Date: Mar 2002 Location: Northampton, UK Posts: 33	How do I get the time to be automatically added to my spreadsheet? Thanks for help, B

Apr 25th, 2002, 10:36 AM	#3
Beckwa New Member Join Date: Mar 2002 Location: Northampton, UK Posts: 33	Thanks B

Apr 25th, 2002, 10:36 AM	#4
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Try CTRL + SHIFT + :