View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

Assuming your timestamps are entered in Excel format (a serial date
number), the formula is
=(B1-A1)*24*60

This can be simplified to
=(B1-A1)*1440
.... but I wanted to show that the 1440 is the result of multiplying 24
hours by 60 minutes.