Mar 2, 2009 at 03:53 AM
Posts181Registration dateMonday January 19, 2009StatusMemberLast seenApril 2, 2009
Mar 2, 2009 at 04:33 AM
Date Created Date Closed
17/02/2013 9:23:03 17/02/2013 10:28:03
These ar my two columns i need to calculate time in hours and time in days !!!
now by doing simple substraction i.e L2-M2 i get time in hours and the to get time in days i divide the time in hours by 24 ok!!!
i get the right answer if the time in hours is greater than 24:00 hrs ... but if the time in hours is 1 hours