Hello, I have a spreadsheet that has validation lists with Multiple date to allow multiple correct TAT from the validation list in the same cell. I appreciate any help.
...Marc
Hi marc5354
You can use custom date forms eg [hh]:mm for your times and add 12
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
JBeaucaires Excel Files
VBA for smarties - snb
Hello Guru,
You are great you solved my query, but still i am looking for something else, like Auto start of Remaining TAT and Escalation Time if user inserted Route Received Date and Time, however Route Complete Date and Time should be PENDING. Please help with this.
Also find the attachment for more information.
Marc.
Anyone can help me regarding my queries.....
...Marc
Hi marc5354,
Can you expand on your requirements??
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
JBeaucaires Excel Files
VBA for smarties - snb
Sir,
Can i explain step by step...
...Marc
ok that would be good
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
JBeaucaires Excel Files
VBA for smarties - snb
Thank you Guru..,
Pls find attached file.,
Condition 1: In K6, i want time between D6-C6, if there is Search start time and Search End time is Pending E6 and F6.
Condition 2: In K6, i want time between F6-E6, if there is Search start time Started by User in E6.
Hi marc5354
for the the button change to
I think it will do what your requireCode:.AutoFilter Field:=10, Criteria1:="<1"
But the rest do you want a timer in the cell?
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
JBeaucaires Excel Files
VBA for smarties - snb
Hello Guru,
Thank you for your time and help..
Please find attached file for with Query details. This is what i want i explained hope this will help us.
Thank you very much Guru
...Marc
Hello marc5354
Can you please make a before and after worksheet on what you require?
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
JBeaucaires Excel Files
VBA for smarties - snb
Good Morning Guru..
Thanks lot for your time..
Yeah, sure why not...., but i don't have any idea about that.
...Marc
Hello Sir,
How are you doing, i added formula to get the time difference between respective columns.
Can you please verify...
Thank you for your time
...Marc
...
Please help me
Hi marc5354
I had a look at the word.doc and I couldnt follow
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
JBeaucaires Excel Files
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks