Thread: Calculate time over two dates
View Single Post
 
Old 07-22-2017, 09:30 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
Try this in E2 and drag down

=IF(C2="","",ABS((C2-A2)+(C2<A2))*1440)
Reply With Quote