Hello is there a way to have a live clock running in a cell with the time of day like below with the seconds ticking?
8:05:35 AM
Thank you in advance
Hello is there a way to have a live clock running in a cell with the time of day like below with the seconds ticking?
8:05:35 AM
Thank you in advance
Enter in any cell
Formula:Please Login or Register to view this content.
Format Custom, hh:mm:ss AM/PM
Actually you would have to use vba to see seconds ticking
Last edited by AlKey; 01-30-2018 at 11:54 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you but it isn't live.
AlKey, I think he wants a running clock that keeps ticking while the sheet is open (correct me if I'm mistaken).
I don't think it is possible without VBA.
here is a link to another site that appears to have addressed it...
https://www.mrexcel.com/forum/excel-...nto-excel.html
here is another link that may have addressed it...
https://www.excelforum.com/excel-pro...ing-clock.html
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Yes I want a live clock and VBA is most likely the only way.
Where to put this module please?
Please Login or Register to view this content.
I attached the file with 'Switchboard' cells E1 and F1 locations for date and running time if that helps.
Thank you so much for the help
I wish I could help but when it comes to VBA I am almost a total novice. When it comes to using VBA the most I can do is copy someone else's code and slightly change things to suit it to my needs.
I just assumed that your request would need something active like VBA and searched on the subject to get the two links I copied.
So I'll have to bow out, good luck and I'll be interested to see what develops.
Could you possibly refer another expert for me please?
I posted your request to the water cooler where they have a thread called call in the calvery for people when they get out of their league or depth here...
https://www.excelforum.com/the-water...-2018-a-2.html
Hopefully someone will see it and stop by to assist.
Your sample file does not include any regular modules. I am not sure why you have put the code in the sheet4 window. I also note that you did not include all of the procedures (like the SetTime subroutine). Starting from the first mrexcel link that sambo kid posted I:
1) opened a new, blank workbook and opened the VBE.
2) In the project explorer pane, I inserted a module.
3) I copied the standard module code from the post into the new module (steps 1 through 3 are discussed in more detail here: https://peltiertech.com/how-to-use-someone-elses-macro/ )
4) I placed the cursor anywhere inside of the shcedrecalc procedure and pressed F5 to start the code running.
At this point, I would guess that the main difficulty is with steps 1 to 3 -- creating a regular module and copying code into it, so review Peltier's essay. Let us know if that helps.
Originally Posted by shg
Perhaps like this?
Don
Please remember to mark your thread 'Solved' when appropriate.
Perfect thank you for the fix Mr. xlnitwit
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks