Mel
Mel

Reputation: 139

Google Sheets time calculations; Summary doesn't work

I create a spreadsheet for a rehearsal plan. I would like to calculate the hours I put in after 6 pm and get a summary of the hours at line E95. For some reason, my summary calculation doesn't work. Maybe one of you can help me out. Thanks a lot in advance! Here's the link: https://docs.google.com/spreadsheets/d/1NSBx87sWScwe2Vtp9FOcH3BupvPJ_jzISUeAk6gSBOM/edit?usp=sharing

Upvotes: 1

Views: 128

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(TEXT(SUM(TIMEVALUE(E4:E93)), "[hh]:mm"))

enter image description here

Upvotes: 1

Related Questions