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, 08:45 AM

xor

Windows 10 subtract date and time and convert to decimal hours ?

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

@NoSparks

You are right. I misread it to have both time and date in one cell.

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 08:44 PM.