Thursday, November 18, 2010

ime difference between two excel cell

Total Hours: INT((B1-A1)*24)


Total Minutes: INT((B1-A1)*1440)


Total Seconds: INT((B1-A1)*104100)


A1 is the larger of the two times.
Posted by at
Labels: , ,

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)