Hello,
I am starting a job where i need to keep track of my own time for projects and clients. I have made an excel workbook to assist with that but I am having trouble with the end rounding function.
I am having the function round to the nearest .1 of an hour (or six minutes). The function I have is [Roundup((End time - Start time) *24,1] and it works perfectly. However the issue I am coming into is if I were to put in 5 different 1 minute intervals it would tell me that I have worked .5 hours which is not true. What is the way that i can modify the function to take into consideration the previous intervals when doing it rounding so that I can more accurately keep my time.
PS, I do know that there is a possible way to do this as when I was interning a former co worker designed a spreadsheet that did just this, but I am no longer able to contact him to help/send a template as he was fired and his files were lost.
Thank you,
I am starting a job where i need to keep track of my own time for projects and clients. I have made an excel workbook to assist with that but I am having trouble with the end rounding function.
I am having the function round to the nearest .1 of an hour (or six minutes). The function I have is [Roundup((End time - Start time) *24,1] and it works perfectly. However the issue I am coming into is if I were to put in 5 different 1 minute intervals it would tell me that I have worked .5 hours which is not true. What is the way that i can modify the function to take into consideration the previous intervals when doing it rounding so that I can more accurately keep my time.
PS, I do know that there is a possible way to do this as when I was interning a former co worker designed a spreadsheet that did just this, but I am no longer able to contact him to help/send a template as he was fired and his files were lost.
Thank you,
