Using Ctrl+Shift+; is great for quickly entering the current time, but it introduces a subtle problem when performing calculations on the values.
Consider a start time and end time entered this way in fields formatted to show HH:MM
Start time: 20:11 End time: 20:20 Duration: 00:08 (End time minus Start time)
Hold on! Shouldn’t the duration should be 00:09?
When I look at the actual figures entered by Ctrl+Shift+;, I see …
Start time: 20:11:48.42 End time: 20:20:26.28
and if I reformat the Duration field as HH:MM:SS, I get the result …
… which of course is correct.
So, my question(s):
Is there an easy way to either truncate the Insert Current Time function (Ctrl+Shift+;) so it only inserts HH:MM, or what’s the easiest way to round that Duration field?