ThrottleWorks
Excel Ninja
Hi,
I have date and time value as ‘10/10/2018 2:02:00 PM’ in a column.
There will be 500-600 values in the column. ‘10/10/2018 2:02:00 PM’ is used as an example.
This value reflects the time particular product hits a department.
For example Yamaha Crux has entered weld shop at ‘10/10/2018 2:02:00 PM’.
It is supposed to get out of weld shop in 60 minutes. So ideal time will be before 3:02:00 PM.
I have a mapping table in my worksheet, 60 minutes is mentioned in a cell.
I am trying to link the formula to mapping table.
I am trying to get the result with a formula.
The formula should return me number of minutes passed from ‘10/10/2018 2:02:00 PM’.
Supposed now it is ‘10/10/2018 2:12:00 PM so the formula will return 50 as answer.
Buffer time is 60 minutes, 10 minutes passed from product hit, 60 – 10 = 50.
I am facing difficulty while calculating numbers when there is date change between two times.
For example how do I calculate difference between ‘10/10/2018 11:30:00 PM’ and ‘10/11/2018 0:15:00 AM’
Formula should return 15 (60 - 45).
And difference between ‘11/11/2018 1:49:00 PM’ and ‘11/12/2018 2:49:00 PM’.
How do I get difference of 25 hours with formula.
I am not able to consider date part in these values.
Forgot to mention, not able to get correct result by using INT formula either.
Not able to understand what mistake I am doing.
Can anyone please help me in this.
PS – Will not be able to upload sample file, apologies.
I have date and time value as ‘10/10/2018 2:02:00 PM’ in a column.
There will be 500-600 values in the column. ‘10/10/2018 2:02:00 PM’ is used as an example.
This value reflects the time particular product hits a department.
For example Yamaha Crux has entered weld shop at ‘10/10/2018 2:02:00 PM’.
It is supposed to get out of weld shop in 60 minutes. So ideal time will be before 3:02:00 PM.
I have a mapping table in my worksheet, 60 minutes is mentioned in a cell.
I am trying to link the formula to mapping table.
I am trying to get the result with a formula.
The formula should return me number of minutes passed from ‘10/10/2018 2:02:00 PM’.
Supposed now it is ‘10/10/2018 2:12:00 PM so the formula will return 50 as answer.
Buffer time is 60 minutes, 10 minutes passed from product hit, 60 – 10 = 50.
I am facing difficulty while calculating numbers when there is date change between two times.
For example how do I calculate difference between ‘10/10/2018 11:30:00 PM’ and ‘10/11/2018 0:15:00 AM’
Formula should return 15 (60 - 45).
And difference between ‘11/11/2018 1:49:00 PM’ and ‘11/12/2018 2:49:00 PM’.
How do I get difference of 25 hours with formula.
I am not able to consider date part in these values.
Forgot to mention, not able to get correct result by using INT formula either.
Not able to understand what mistake I am doing.
Can anyone please help me in this.
PS – Will not be able to upload sample file, apologies.
Last edited:
