I have a simple timesheet devised in
Google sheets and simply want to calculate how many hours and minutes have elapsed since the start time, so I can then calculate how any total hours oof overtime have occured.
I have tried two approaches:
- Formatted the "time started" and "time end" columns as "time" (format > number > time) and the "hours" column is formatted as "automatic" in my first example. Using
SUM(), I've tried to get the total number of hours, but as you can see from row 49 in my demo below, the hours are incorrect for whatever reason.
- I've then tried to use "duration" instead of "automatic" for my "hours" column, but it provides minus numbers, which when summed, will not provide the correct hours.