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.
Total Minutes: INT((B1-A1)*1440)
Total Seconds: INT((B1-A1)*104100)
A1 is the larger of the two times.
No comments
Post a Comment