- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 07, 2021 06:36 PM
Hi All! First time in the community. I’ll have a bunch of questions but wanted to know if there’s an easy way to do a formula to convert a duration field from hh:mm (hours and minutes) to hh.hh (hours with a decimal)
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 07, 2021 08:44 PM
Welcome to the community, @Ted_Willett! :grinning_face_with_big_eyes: Internally, duration fields store entered time as a whole number representing the number of seconds. So if the hh:mm display shows 1:00 (1 hour), the internal value is actually 3600. To get hours with fractions, divide that duration field by 3600, and make sure the field formatting displays as a decimal value.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 07, 2021 08:44 PM
Welcome to the community, @Ted_Willett! :grinning_face_with_big_eyes: Internally, duration fields store entered time as a whole number representing the number of seconds. So if the hh:mm display shows 1:00 (1 hour), the internal value is actually 3600. To get hours with fractions, divide that duration field by 3600, and make sure the field formatting displays as a decimal value.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 07, 2021 09:37 PM
wow - how simple - thanks for not making fun of me - my newb is showing!
