Thursday, November 14, 2013

EXCEL : Calculate the time difference between two times

4: EXCEL : 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.
Photo: EXCEL : 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.
at

1 comment:

  1. Unknown14 November 2013 at 20:33

    What will happy if the timing is today night and tomorrow morning for example

    22:00 hrs (10:00pm) - 05:00 hrs (05:00am) ?

    ReplyDelete

Subscribe to: Post Comments (Atom)