Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
i need to make the time duration as 00:00:01 when it is 00:00:00. Can you please help me, am attaching the sample data.
Duration |
00:12:36 |
00:00:00 |
00:10:25 |
00:00:00 |
01:01:15 |
01:02:06 |
00:00:00 |
00:00:22 |
00:12:06 |
You could try it with:
time(rangemax(Duration, maketime(0,0,1)), 'hh:mm:ss')
- Marcus
You could try it with:
time(rangemax(Duration, maketime(0,0,1)), 'hh:mm:ss')
- Marcus
Thank you Marcus. Its working fine.
Hi,
I have already applied IF(Duration='00:00:00','00:00:01',Duration) expression, this is working but disturbing the other duration values.