|
|
#1
01-20-2017, 04:27 PM
|
|||
|
|||
subtract date and time and convert to decimal hours ?
Hi,
column A is time format, column B is date format, column C is duration in decimal hours of that pair from the row above. A B C 1 12:45:00 14-Jan-2017 2 00:30:00 16-Jan-2017 35.75 what formula to use in C to get the duration as decimal hours please ? I see in another thread =MOD(A63-A62,1)*24 to crossover a day but poster hadnt a date column , I have more than 1 day gaps ! DBenz 
|
|
|
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 |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode