EXCEL formula for Time
By rlimosnerojr •
Need your help guys who knows more about Excel.
I have this file that I want to solve.
I have to solve the time difference that automatically computes the Hours and Minutes in the process.
Scenario.
If B3 IS < or = to A3, result must be On Time else Late.
But I want to solved this scenario below
Standard Time of arrival defaults: 01:40 today
Data Time received: 23:30 yesterday
Result should read show as: On Time.
Please do help me to create a formula in excel.
Thank you so much
Roger
Thank you so much but can below scenario is I want to solve
But I want to solved this scenario below
Standard Time of arrival defaults: 01:40 today
Data Time received: 23:30 yesterday
Result should read show as: On Time.
Please do help me to create a formula in excel.
Thank you so much
=IF(A3>=B3,"On Time","Late")