asked on May 9, 2023
Hi,
I have a list of hours:minutes and the sum result is wrong when I select all of them.
0:00, 1:02, 0:39, 0:00, 0:00, 0:00, 1:13, 2:00, 2:00, 1:55, 0:00, 0:00, 2:00, 1:58, 2:00, 2:00, 2:00, 0:00, 0:00, 0:17, 1:21, 0:00, 1:24, 0:00, 0:00, 0:00, 0:20, 0:00, 0:00, 2:00, 2:00
The result should be 26:09 but instead its showing 26:10.
In the attached files i have the wrong sum with flexmonster and the correct sum from somewhere else.
Best Regards,
Tiago
⋅ May 10, 2023
Hello, Tiago!
Thank you for contacting us.
As we can see from the provided screenshots, you had the time pattern H:mm, which does not show seconds, but in calculations, seconds are included. This may lead to an additional minute in the calculation results.
Hope you will find our answer helpful.
Feel free to contact us in case of any other questions.
Regards,
Solomiia
⋅ May 10, 2023
Hi Solomiia,
Is there any way to ignore the seconds?
Best Regards,
Tiago
⋅ May 11, 2023
Hello, Tiago!
Thank you for your swift response.
We kindly recommend modifying the data and removing extra seconds before passing it to Flexmonster.
Hope it helps.
Do not hesitate to contact us if any other questions arise.
Regards,
Solomiia
⋅ May 11, 2023
Hi Solomiia,
Thanks for the reply, I'll have a look about removing the seconds.
Best Regards,
Tiago
