time report snippets

Total hours between start and end time - Google Spreadsheet

Tagged format, google, spreadsheet, time, time report  Languages 

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

For example:


To achieve this in a Google spreadsheet we can use the following formula:


Reference: https://infoinspired.com/google-docs/spreadsheet/payroll-hours-time-calculation-in-google-sheets/