This simple macro will put the current time into the active cell
'Routine to Enter current time in active cell
'Change format as required
.Value = Time
.NumberFormat = "hh:mm"
Put the macro in a standard module in the Personal.xls workbook
The easiest way to use this is to put a button on a toolbar and link it to this macro. When you have selected a cell, clicking the button will put the time in the cell.
A better way is to add an insert time option to the right click cell shortcut menu, but this is a little more complicated.
Note that this macro only puts the time in the cell.
If you need date as well it can easily be modified.
The time format is 24hrs e.g., 16:10
but it can be changed in the format line in the macro.
To calculate hours, if start time is in A2 and finish time in B2
In C2 put =B2-A2
You can add the break duration
Enter it in D2 as 0:45
The formulas in C2 and E2 are also shown
A B C D E
1 Start Finish Total Break Worked
2 8:00 17:47 9:47 0:45 9:02
This calculation will not work if finish time is after midnight, but there are ways of dealing with that, if it is an issue.