Feature Request – Time Format (Hours and Minutes) in Spreadsheets Workiva
I am experiencing an issue with time formatting in spreadsheet cells within the platform. Currently, Workiva interprets decimal numbers in base 10, which affects calculations involving hours and minutes.
Identified Issue:
- When I enter values like
3:35(representing 3 hours and 35 minutes) and3:30 (3 hours and 30 minutes), the system treats them as decimal numbers (3.35and3.30) instead of a base 60 time format (hours and minutes). - This causes errors when summing time periods, as Workiva does not correctly convert minutes when they exceed 60.
Suggested Solution:
It would be extremely helpful to include a time (hours and minutes) cell formatting option within the "Value Formatting" section, allowing users to configure cells to correctly interpret values in the hh:mm format.
I have attached a screenshot illustrating the issue. This enhancement would help eliminate the need for manual formulas to convert decimal values into real-time durations.
Thank you for your attention, and I look forward to your response regarding the feasibility of this suggestion.
-
It would be very helpful to be able to work with the hour format in Workiva.
3
Having the ability to work with the hour format in Workiva would be extremely useful.
1
Thanks for sharing this suggestion Thiago, and for chiming in as well Fernando and Tatti! Will get this over to development and share your insights with the team. Much appreciated.
1
Excellent suggestion!2
Great suggestion!!!
1
Great suggestion!
1
Thanks for suggestging this enhancement, Thiago!
1
Thanks Thiago. This is a great suggestion!
1
This would be super helpful for displaying chains and query outputs in the sheets. We would use this a ton!
0
Hi Miller Stephens - Thanks for adding your input here. I have you added to the request and encourage others passing by that would benefit from this feature, to please comment! Happy Friday!
0
Hi, I just wanted to check if there are any updates on this. 😉
0
Olá Tatti!
This idea is under future consideration and seems likely to be worked on. I don't have a timeline for when as of yet but its a positive sign. Thanks for chiming in, as always, and have a super day!
0请先登录再写评论。
评论
12 条评论