End time minus start time gives a fraction of a day. Multiply by 24 to get hours: =(E2-D2)*24, then format the column as a number.
Full tutorials on YouTube: SheetCompanion
Voiceover created with AI (ElevenLabs). Spreadsheets built and tested by SheetCompanion.
Spreadsheet templates:
Also on Etsy:
source