Thread
:
Urgent Help Needed with coloumn compare
View Single Post
#
2
Dave O
Posts: n/a
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.
Reply With Quote