This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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)
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.
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.
