Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu

FAQ

Thread Tools

Display Modes

11-25-2017, 03:11 PM

AlanBird

Windows 10 Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu

Office 2016

Novice

Join Date: Nov 2017

Posts: 2

The term MOD(D14-B14,1) handles the case where the start time (B14) is one day and the end time (D14) is the next day ("runs past midnight"). Note: if D14-B14 is zero, that will be interpreted as zero time, not 24 hours.[/QUOTE]

Thank you that worked perfectly.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't figure out a formula - Vlookup or something else?	Redsox	Excel	3	08-25-2017 08:54 AM
formula using equals/greater than etc signs	msnarayanan	Excel	2	02-25-2016 08:21 AM
Need help with excel formula greater than..	bm868	Excel	2	01-02-2016 10:29 AM
Automatically change the value of one cell so that two other cells become equal	matthew544	Excel	5	09-18-2011 08:56 AM
If A1 greater than or equal to 1 Then A3 = A2*A1	brians	Excel	5	03-09-2010 12:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:45 PM.