|
Hi there.
Think this is what you are looking for.
Main thing to remember is that when a time is entered into excel in hh:mm format that excel actually records that as a decimal number (12:00 is 0.5, 24:00 is 1). Therefore took the difference between the times and multiplied by 24 to get the difference (in integer form). I then had to separate the hours from the minutes using the left and right formulas. There may be a simpler way to do this mathematically, but I'm not sure.
Let me know if this worked for you.
|