I track how much time I work in a week in a note. This function takes that unstructured format and calculates how much time I work each day and week.
The input looks like:
Monday 9:55-12:33 lunch 1:30-6:28
Tuesday 9:58-1:35 lunch 2:28-6
Wednesday 9:16-12:57 apple, lunch travel, and break 3:25-6:45
The output looks like:
Weekly Report:
Monday 9:55am-12:33pm 1:30pm-6:28pm 7 hours 36 minutes
Tuesday 9:58am-1:35pm 2:28pm-6pm 7 hours 9 minutes
Wednesday 9:16am-12:57pm 3:25pm-6:45pm 7 hours 1 minutes
I worked 21 hours and 46 minutes