Nov-05-2020, 01:56 AM
Hi, I have a very tricky (for me) time conversion.
I have string:
Start time, End Time, Total Time, other stuff, more stuff, more stuff, and more
2020-11-02 16:53:14, 2020-11-03 08:41:47, 15:48:33, JP04TNNV0015EN, Bell_13, TT_Dev, TG LK A
I need to split the total time between two days so I'll get two strings like this:
2020-11-02 16:53:14, 2020-11-03 00:00:00, 07:07:46,JP04TNNV0015EN,Bell_13, TT_Dev,TG LK A
2020-11-03 00:00:00, 2020-11-03 08:41:47, 08:41:47,JP04TNNV0015EN,Bell_13, TT_Dev,TG LK A
Sometimes I need to split total time between two, three, or more days.
I'm not sure how to even start.
Thank you again!
I have string:
Start time, End Time, Total Time, other stuff, more stuff, more stuff, and more
2020-11-02 16:53:14, 2020-11-03 08:41:47, 15:48:33, JP04TNNV0015EN, Bell_13, TT_Dev, TG LK A
I need to split the total time between two days so I'll get two strings like this:
2020-11-02 16:53:14, 2020-11-03 00:00:00, 07:07:46,JP04TNNV0015EN,Bell_13, TT_Dev,TG LK A
2020-11-03 00:00:00, 2020-11-03 08:41:47, 08:41:47,JP04TNNV0015EN,Bell_13, TT_Dev,TG LK A
Sometimes I need to split total time between two, three, or more days.
I'm not sure how to even start.
Thank you again!