2014年5月4日 星期日

Calculate the time difference between two times

Calculate the time difference between two times

=TEXT(C4-B4,"H") Hours between two times.

=TEXT(C5-B5,"HH:MM") Hours and minutes between two times. 

=TEXT(C6-B6,"HH:MM:SS") Hours, minutes, and seconds between two times.


沒有留言:

張貼留言