|
Los tipos de archivo clásicos dejarán de estar disponibles a partir de enero de 2021. Puedes migrar tus archivos clásicos o descargar un PDF. Más información

Feature Request – Time Format (Hours and Minutes) in Spreadsheets Workiva

Solicitar demostración

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) and 3:30 (3 hours and 30 minutes), the system treats them as decimal numbers (3.35 and 3.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.

10

Comentarios

12 comentarios

Fecha Votos
  • Fernando Santoro

    It would be very helpful to be able to work with the hour format in Workiva.

    3
  • Tatiana Nunes

    Having the ability to work with the hour format in Workiva would be extremely useful.

     

    1
  • Mike Davis

    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
  • Kelly Menezes 
    Excellent suggestion!
    2
  • Ana Paula Tavora

    Great suggestion!!!

    1
  • Renata Queiroz

    Great suggestion!

    1
  • Marcelo Siqueira

    Thanks for suggestging this enhancement, Thiago!

    1
  • Alan Lima

    Thanks Thiago. This is a great suggestion!

    1
  • Miller Stephens

    This would be super helpful for displaying chains and query outputs in the sheets. We would use this a ton!

    0
  • Brooke Mortvedt

    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
  • Tatiana Nunes

    Hi, I just wanted to check if there are any updates on this. 😉

    0
  • Mike Davis

    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

Iniciar sesión para dejar un comentario.