i want to check for time difference. Like if time is between 10:53 PM to 12:53 AM than it'll show as C if it is other then A. how to do this

With your data like: A B C 1) Start Time End Time Total 2) 10:53 PM 12:53 AM 2:00Try this:

=IF(B1<A1,(B1-A1)+1,B1-A1)

Since your end time, 12:53 AM is after Midnight, we need to add a Day to the formula,

(B1-A1)+1

also format cell C2 as[HH]:MM<< the Brackets are required.MIKE

message edited by mmcconaghy

Ask Your Question

Weekly Poll