Converting Time from hours and minutes to decimal hours for rate calculating

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! :smiley: 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.

1 Like

wow - how simple - thanks for not making fun of me - my newb is showing!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.