I want to extract the total hours worked from a Google spreadsheet.
Given the following data in a Google spreadsheet:
- End time in column D using time format
- Start time in column C using time format
start,end,hours 10:00,12:00,2 9:00,12:00,3
To achieve this in a Google spreadsheet we can use the following formula: