How Do I Get The Difference In Hours and Mins
Hi
I'm working in a freight forwarding company. I basically need to know the formula to get the difference in hours and mintues base on the PDF file attached. Please note that the date and time are together in one cell for example A1 (d/mm/yyyy hh:mm). Hope someone can help me with this issue.
Kindly see attached.
A1
31/07/2005 20:15
B1
1/08/2005 08:50
C1
B-A = hh:mm
Thanks in advance!
Cheers
Eugene
Last edited by medicom06 : August 11th 05 at 08:02 AM
|