I need to calculate the Total Hours,
Total Hours = Received date (Minus) Sample Date.
DaysBetween function worked to calculate the Number of days in between but similarly how to calculate number of hours between two dates, is there any specific function for that or do i need to write the any logic.
Please suggest me what to do?
Please let me know what kind of a logic I need to use to implement this.
It worked fine, but I tried the look at the data in different way.
For example:
Recieve Date -------------------------------Received Date---------------------------- Time gap ----------------------Total Hour
09/16/2012 3:27:01 PM -------------11/2/2012 2:47:04 PM------------46 days(s) 23:20:03----------------------1127 hrs
So your logic is looking good, its calculating the Time gap between two time stamps, but I am looking for just hours between them.
I tried changing the logic little bit but it end up showing the result as 23 Hours instead of 1127 hours, I guess my logic did not calculated the days.
Please let me know if there is an easy way to write that kind of logic.