Forum Discussion
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.
| Job | Start time | End time | Hours | Min | Sec |
| 1 | 19-12-2022 00:00:00 | 19-12-2022 24:00:00 | 24 | 0 | 0 |
| 2 | 19-12-2022 00:00:00 | 20-12-2022 01:15:30 | 25 | 15 | 30 |
In D2:
=INT(24*(C2-B2))
In E2:
=INT(MOD(1440*(C2-B2), 60))
In F2:
=MOD(86400*(C2-B2), 60)
Fill down.
For the sum:
Days:
=INT(SUM(C2:C3-B2:B3))
Hours:
=MOD(INT(24*SUM(C2:C3-B2:B3)), 24)
Minutes:
=MOD(INT(1440*SUM(C2:C3-B2:B3)), 60)
Seconds:
=MOD(86400*SUM(C2:C3-B2:B3), 60)
- Hi HansVogelaar,
Thanks for your great help : )
