Skip to content
Discussions
Topics
Support
Product Ideas
Help & Learning
Sign in
Try Smartsheet
Julie@WD
Julie@WD
Clear
Search
Loading
Home
›
Julie@WD
›
Promote
Julie@WD
✭✭✭✭
Overview
Overview
Roles
Member
Badges
15
About Me
About Me
Not much happening here, yet.
Analytics
20
Posts
266
Visits
313
Points
Feb 15, 2019
Join Date
5:11 pm
Last Active
Reactions
Promote 1
1
Insightful 1
1
Vote Up 1
1
Activity
Discussions
6
Comments
14
How I calculate HH:mm
Julie@WD
03/11/24
Here's how I figured out HH:mm. I welcome all simplification suggestions. The combined formula in A38 is this monstrosity (but it works): =IFERROR(IF(INT(SUMIFS({Duration}, {CURWK}, 1, {Event Type}, …
5
·
Activity
Discussions
6
Comments
14
Badges