Thread: subtract date and time and convert to decimal hours ?
View Single Post
 
Old 01-20-2017, 04:27 PM
DBenz DBenz is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
  
Join Date: Dec 2014
Posts: 69
DBenz is on a distinguished road
Default 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
Reply With Quote