S
sorabh
guyz
i m in much need of your help,
i have an exported report from Remedy which is in a csv format,
the dates in it follow this pattern 1/27/2004 11:26:00 AM,
i need to parse the date and time out of this field and use them
in calculations. How to do this ?
Also i want to calculate the no. of business hours (8 hour per working
day) between two such time stamps (excluding the week days and any
holidays).i can start using network days but before that i need that
11:26:00 AM in a different cell from where i can manipulate that value,
so is the case with the date
Plzzzzzzz needed help urgently
i m in much need of your help,
i have an exported report from Remedy which is in a csv format,
the dates in it follow this pattern 1/27/2004 11:26:00 AM,
i need to parse the date and time out of this field and use them
in calculations. How to do this ?
Also i want to calculate the no. of business hours (8 hour per working
day) between two such time stamps (excluding the week days and any
holidays).i can start using network days but before that i need that
11:26:00 AM in a different cell from where i can manipulate that value,
so is the case with the date
Plzzzzzzz needed help urgently