Hi there..
I have 2 date fields in my table. I want to subtract these 2 date fields to get the result in hour and minute.
Below is what I have and what I am doing but the result is not as I want..
Date1 Date2 date2-date1*24 (is what I am doing)
21-06-2011 14:00:00 21-06-2011 16:55:00 2.9166667
21-06-2011 07:00:00 21-06-2011 16:50:00 9.8333333
21-06-2011 07:20:00 21-06-2011 16:30:00 9.1666667
I want to deduct date2 from date1 and represent hours and minutes in one decimal figure.
Date1 Date2 date2-date1*24 (this is how I want)
21-06-2011 14:00:00 21-06-2011 16:55:00 2.55
21-06-2011 07:00:00 21-06-2011 16:50:00 9.5
21-06-2011 07:20:00 21-06-2011 16:30:00 9.5
I guess its simple arithmetic but im not getting it right..Any help will be very much appreciate. Thanks in Advance x 1000 times.
Regards,
Mack