Sorry in advance if this is the wrong section, but here we go..
So I have two dates with times included. 3/10/2012 8:20 and 3/13/2012 11:35
I need to find the amount of hours between these two dates. I have used (date2-date1) and formatted it with [h].mm
but the problem is I need the minutes to be percentages of the hour, so for example I get 7.15 and the correct answer is
7.25 because 15 mins is 1/4 of an hour (duh). I'm just really stuck and any help would be appreciated, thanks again in advance
and hope you have a great day.