Forum Discussion
Calculate leadtime from a log file
Hi guys I have a log fle that look something like this Project Project Status Project Status Entry Timestamp 23-272 1.1 24.09.2023 19:30 23-272 1.2 24.09.2023 19:51 22-132 1.1...
Your sample data seems to be missing the seconds and your expected outcome seems to be missing the days. Please clarify. Please also indicate how to handle weekends, holidays, and business hours.
Sorry for that.
It shoud only adopt to business hours and all lead time should be in hours and minutes