Excel & Word-Tips & tricks
Thursday, November 14, 2013
EXCEL : Calculate the time difference in one time unit
5:
EXCEL : Calculate the time difference in one time unit
=INT((C4-B4)*24) Hours between two times.
=INT((C5-B5)*1440) Minutes between two times.
=INT((C6-B6)*86400) Seconds between two times.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment