hi everyone,
does anybody knows an idea how to get the time difference without getting the #NUM! error message?
Column A contains Start Time while Column B contains end time, if the time in column A is 11:45 PM and the time in column b is 12:15 AM, then I would get this error message...any idea how can i get the time difference without having to use the [hh]:mm format? i would like to use the hh:mm AM/PM format instead. I appreciate any response.
Thanks,
Stoey
Bookmarks