Forum Discussion
Converting duration value in decimal format to corresponding timeclock value in hh:mm:ss format
Hi Anonymous . Thank you for your reply. You can refer to (“data.csv” : "data.csv" file ) showing the same outputs you got but notice that, for instance, 256,25 hours (duration in decimal format) is different than 16:25:00 duration in timeclock format mainly because, as you have well explained, "hh cannot exceed 24 in the standard time format". So my problem remains unsolved 😞
My final goal is: finding a way to compare my duration time in decimal format (from column “SM_TTR_NET”) with the time range ("TO" from the table below) in standard time format hh:mm:ss so I know which Credit% I need to apply?
Would then be better (due to this limitation of " "hh cannot exceed 24 in the standard time format") to do other way around and finally convert the table below to decimal format (for instance, "TO" 04:00:00 -> 4,00) so I compare it with the duration time also in decimal format from column “SM_TTR_NET” ?
| Duration references (hh:mm:ss) | Credit % | |
| FROM | TO | |
00:00:01 | 04:00:00 | 0% |
04:00:01 | 08:00:00 | 10% |
08:00:01 | 12:00:00 | 30% |
12:00:01 | 24:00:00 | 50% |
24:00:01 |
| 100% |
You can see the results I got below in the attached csv file
Thank you!