Convert the text to date and time format, calculate the processing tim
Hi Expertise,
I need your help. I have a problem about the sum of processing time from the data in text format as below. Can i get the answer of the sum of the following 2 jobs as 2 Days, 1 Hour, 15 Min and 30 Sec?
Thanks for your great help in advance.
JobStart timeEnd timeHoursMinSec119-12-2022 00:00:0019-12-2022 24:00:002400219-12-2022 00:00:0020-12-2022 01:15:30251530
Hi Expertise,I need your help. I have a problem about the sum of processing time from the data in text format as below. Can i get the answer of the sum of the following 2 jobs as 2 Days, 1 Hour, 15 Min and 30 Sec?Thanks for your great help in advance. JobStart timeEnd timeHoursMinSec119-12-2022 00:00:0019-12-2022 24:00:002400219-12-2022 00:00:0020-12-2022 01:15:30251530 Read More
