Hi,
I have data in the following format
dd/mm/yyyy hh:mm
I need to extract the "hh:mm" data into a separate cell in order to add it to a different "dd/mm/yyyy" entry. hope you can help.
Alternatively, the reason i'm doing the above is to establish the elapsed WORK time between two dates - i.e. taking the weekends out. is there an easier way?
Thanks for your help,
Grey
I have data in the following format
dd/mm/yyyy hh:mm
I need to extract the "hh:mm" data into a separate cell in order to add it to a different "dd/mm/yyyy" entry. hope you can help.
Alternatively, the reason i'm doing the above is to establish the elapsed WORK time between two dates - i.e. taking the weekends out. is there an easier way?
Thanks for your help,
Grey