Entering time and date is fine - but what I do in mine is then work in 3 places past the decimal in all the calculations (so 1.5 = an hour and a half for example), then wrote a simple algorithm to turn that into hours and minutes in two columns wherever I need totals outputs to that level of accuracy. ![]() The biggest problem with Excel, and its a pretty trivial one, is that it doesn't handle minutes well in calculations. You're welcome to a copy of mine to play with it you want to drop me a PM with your email address, but I'm sure that one is as good as mine, and with either, as it's in Excel you can just muck about with it to tailor it to your own exact requirements. I don't plan to stop using my paper logbook and it's a moot point which is backing which up, but I find Excel an excellent tool for the task. Unsurprisingly perhaps, it's extremely similar to the one at that link - as presumably he and I were both trying to solve basically the same problems with the same tool.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |