Continuous Clock in excel sheet and date that updates automatically and starts as soon as

Hi

I need to add a Continuous Clock in excel sheet and date that updates automatically and starts as soon as soon as the program starts


I have tried various ones that i have found but it does not update or puts into multiple sheets

The program I made : I need the info on Sheet 2 ("Invoice")
and only in this workbook

I need the current date every day in E5 and the continuous clock in E28 and I need the clock to start and date to update as soon as the program is opened and it must be a continuous clock


Please Please Please

Help !!!!

Debra

The NOW() formula would provide the date+time you need. However, these do not refresh automatically but only when asked to recalculate or when opening the workbook. I did find something that might help you but maybe not:
http://www.mrexcel.com/forum/excel-q...worksheet.html
You can continue searching for a way to autorefresh the NOW() formula though.

Here is the one I have been testing ....it puts date and time in all sheet in workbook.... and it doesnt update when reopened ... the problem with the Now() is that my invoices are saved in excel format as i havent quiet figured out how to pdf the vba yet.... still learning.... so when I have to reopen the invoices then the current date gets set and not the invoice date



Dim SchedRecalc As Date

Sub SetTime()

SchedRecalc = Now + TimeValue("00:00:01")
Application.OnTime SchedRecalc, "Recalc"
End Sub

Sub Recalc()
Set WS2 = Worksheets("Invoice")
Range("E28").Value = Time
Range("E5").Value = Format(Now, "dd-mmm-yy")
Call SetTime
End Sub

Sub Disable()
On Error Resume Next
Application.OnTime EarliestTime:=SchedRecalc, Procedure:="Recalc", Schedule:=False
End Sub