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.