Thread: subtract date and time and convert to decimal hours ?
View Single Post
 
Old 01-21-2017, 07:41 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Quote:
i have more than 1 day gaps !
Try
= ((B2+A2)-(B1+A1))*24
Reply With Quote