subtract date and time and convert to decimal hours ?

		Microsoft Office Forums > Microsoft Excel > Excel
subtract date and time and convert to decimal hours ?

01-21-2017, 07:41 AM

NoSparks

Windows 7 64bit subtract date and time and convert to decimal hours ?

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Quote:

i have more than 1 day gaps !

Try
= ((B2+A2)-(B1+A1))*24

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert [h]:mm:ss to Decimal Hours to Count FTE for Month	Ethan2015	Excel	2	09-18-2015 03:55 AM
Formula for decimal hours from two date time entries	DBenz	Excel Programming	0	01-15-2015 05:52 AM
Converting decimal to hours	jhwtsang	Excel	4	05-16-2011 01:36 PM
Date and time calcs excluding non-working hours	mrsatchmo	Excel	1	01-26-2011 08:50 AM
Convert hours in decimal	ghostones	Excel	1	12-29-2009 09:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:49 AM.