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
Converting Time from hours and minutes to decimal hours for rate calculating
+7Best answer by Justin_Barrett
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.
+21Welcome 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.
+7Welcome 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.
wow - how simple - thanks for not making fun of me - my newb is showing!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.