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
Feb 28, 2025
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