I need to format cells as H:MM for various work durations, so that SUM will give me total hours

[librebill]

Date 1 Person A Task x 1:15
Date 1 Person B Task y 2:00
Date 1 Person A Task y 0:45
Date 1 Person C Task x 0:12

Total All Tasks 4:12

[anon73440385]

Hello,

see the following sample file: WorkDuration.ods, where format of cells D2:D7 is: [HH]:MM (brackets indicate using durations; i.e. time differences, and thus allow for more than 24 hours)