GeekInterview.com
Series: Subject: Topic:
Question: 6 of 33

how to subtract 2 dates to get the result in hour and minute

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
Asked by: K Mack Ahmed | Member Since Sep-2011 | Asked on: Sep 17th, 2011

View all questions by K Mack Ahmed

This Question is not yet answered!

Related Open Questions

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.