Hi. I have a spreadsheet which is a sort of time sheet. In column E I have dates. In column C I have times that are suggested durations for tasks to be completed on certain days. I'm trying to populate a textbox on a user form with the remaining time left of all the tasks yet to be completed. When a task is completed it is marked in column H as "Y". I'm only really concerned with today's date and the remaining tasks for today but cannot seem to find a way to sum all the times in column C based on todays date. I've tried using the Today(), Date() and lots of other variations but none of them seem to work in any way shape or form despite looking at over 100 pages on google that say it should work.
Essentially I want the textbox on the userform to populate with the remaining time left but can't find a way to do it.
Essentially I want the textbox on the userform to populate with the remaining time left but can't find a way to do it.