Hi
i have a timing list in excel sheet…
In Time : 09.57:02 not equal to Zero or null
As show in image write status based on In time is greater one min or Not… if greater one mins wrtite cutoms text…or else write Less than Zero Mins…
Thanks
Shyam
You are duplicating the same request. Creating duplicates of posts is not recommended. It will not solve your question sooner.
I suggest you continue finding a solution in your original thread Based on Time bot write Present or Absent
Hi @jeevith
Can you help to solve my issue…
DateDiff(dateinterval.Minute,Convert.todatetime(your variable for in time),Convert.todatetime(your variable for out time))
take your time as a string
string.substring(1,2)
use nested if to find it by convert string to int
Hi @Shyam_Pragash,
@ashwin.ashok has already provided you an answer in the original thread.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.