Ask Your Question
0

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

asked 2020-03-26 23:29:10 +0200

librebill gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-03-26 23:55:03 +0200

Opaque gravatar image

updated 2020-03-26 23:56:09 +0200

Hello,

see the following sample file: C:\fakepath\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)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-03-26 23:29:10 +0200

Seen: 20 times

Last updated: Mar 26