Solved how to put if formula for a fix time difference in excel

May 6, 2017 at 04:29:48
Specs: Windows 8
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

See More: how to put if formula for a fix time difference in excel

Report •

#1
May 6, 2017 at 06:22:13
✔ Best Answer
With your data like:

        A          B          C
1) Start Time	End Time    Total
2) 10:53 PM	12:53 AM     2:00

Try 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

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question