I have time in the following format.
9/27/2006 5:49:17 PM
In another column I have time as 3:00:00 PM.
Now, I need to subtract times, but the format 9/27/2006 5:49:17 PM is causing issue and I'm not able to sub time and get the information. Can I use the Text(...."hh:mm....) etc
9/27/2006 5:49:17 PM
In another column I have time as 3:00:00 PM.
Now, I need to subtract times, but the format 9/27/2006 5:49:17 PM is causing issue and I'm not able to sub time and get the information. Can I use the Text(...."hh:mm....) etc