How do I make a clock?

I want my spreadsheet to show the time on my computer changing each second

I will then input in 3 separate cells called:
hour
min
sec

I will then add or subtract this time onto another clock that changes each second.

How do I do this?

See Andypope solutions:

http://www.andypope.info/fun/clocks.htm

Or use this macro (change C3 and C4 for displaying result in other cells):

Please Login or Register  to view this content.

I can't get it to work. However, I'm not a very good programmer.

Tell me if I left out a step

I started a new file
r click on sheet 1
selected view code
pasted your code on the page
saved my file as clock 2.xlsm

Instructions


Open the workbook

Press the "Alt" and "F11" keys together to access the VBE. This opens up a window with the Visual Basic for Applications (VBA) code.

pasted your code on the page
save your file as clock 2.xlsm

Thank you I got it working!

Now I need to add or subtract hours minutes and seconds

Hours would be in cell e4, min in f4, seconds in g4

example, I want to add 2hours 23 min and 17 sec
e4 = 2
f4 = 23
g4 = 17

How do I make a new timer to add this time to the clock?

I'd also like a data validation list that says "add" and another "subtract" because sometimes I want to subtract this time

I don't know how to add or subtract time

I can convert 2:23:17 into 8597 seconds. However if I add this to c4, I can't read the display

Can c4 be separated into 3 cells?