Creating a timer

[SalamanderSam14]

Im looking to create a timer which starts running when i open excel and which pauses when i close it, but does not reset when i reopen excel, i then want to view this timer in a cell.

I currently have a timber that works using cells to start, pause and reset the timer however it only works if the start timer is clicked and does not continue running when i use other cells in excel, To see this code please message back and ill post it if you find it relevant

Thanks for any suggestions

[brynbaker]

Here is code that does it. Place it in ThisWorkbook module.

Please Login or Register  to view this content.

In a new sheet, define these cells in A2:A5
Session started
Session ended
Session Duration
Total time
Use the Names deine tool to name the cells B2:B5 from teh left column (so matching te code in [brackets].
You can hide the sheet if you wish (as long as it's not the only one).

To see the value, either don't hide the timer sheet of place a forumla =[Total_time} somewhere/
Voila!

[brynbaker]

I should habe mentioned that B4:B5 must be formatted [H]:mm:ss to show the times correctly.
B2:B3 will be formatted when the file is opened after the first save, or you can use dd/mm/yyyy hh:mm

[brynbaker]

I'm now at a computer where I can upload the solution: timer.xls
Does that warrant a star?

[briantabb]

I a new to this forum so bear with me. I love excel potentials but it will be a wile before I can contribute to answer a question on Excel.