I need to validate the hh.mm.ss and
- convert the Seconds, if its over 59 and increment it the minutes to 1 validate
- check minutes, if its over 59, then increment the hour by 1 and convert the rest as Minute
1) Do you need an advise on the sequence of operations to produce your result? Or
2) Do you need your job to be done by someone else, and you were provided with a ready-to-copy-and-paste working code?
P.S.
From my primary school days I remember: the required process is called "rounding the time value"
P.P.S.
Do you need also to update the date value after your hours value becomes 24 or more? Such as:
12/31/2024-23.59.59.999999 -> 01/01/2025-00.00.00.000000
Joined: 30 Apr 2020 Posts: 13 Location: United States
sergeyken wrote:
Please, clarify you post:
1) Do you need an advise on the sequence of operations to produce your result? Or
2) Do you need your job to be done by someone else, and you were provided with a ready-to-copy-and-paste working code?
P.S.
From my primary school days I remember: the required process is called "rounding the time value"
P.P.S.
Do you need also to update the date value after your hours value becomes 24 or more? Such as:
12/31/2024-23.59.59.999999 -> 01/01/2025-00.00.00.000000
Hi
I tried using the below approach using MOD but i'm getting error using MOD
1) Do you need an advise on the sequence of operations to produce your result? Or
2) Do you need your job to be done by someone else, and you were provided with a ready-to-copy-and-paste working code?
P.S.
From my primary school days I remember: the required process is called "rounding the time value"
P.P.S.
Do you need also to update the date value after your hours value becomes 24 or more? Such as:
12/31/2024-23.59.59.999999 -> 01/01/2025-00.00.00.000000
Hi
I tried using the below approach using MOD but i'm getting error using MOD
Joined: 30 Apr 2020 Posts: 13 Location: United States
sergeyken wrote:
andy12 wrote:
sergeyken wrote:
Please, clarify you post:
1) Do you need an advise on the sequence of operations to produce your result? Or
2) Do you need your job to be done by someone else, and you were provided with a ready-to-copy-and-paste working code?
P.S.
From my primary school days I remember: the required process is called "rounding the time value"
P.P.S.
Do you need also to update the date value after your hours value becomes 24 or more? Such as:
12/31/2024-23.59.59.999999 -> 01/01/2025-00.00.00.000000
Hi
I tried using the below approach using MOD but i'm getting error using MOD
.jpg)
