Conditional Currency

  • Thread starter Thread starter Loadmaster
  • Start date Start date
L

Loadmaster

Cell A1 has the number of hrs I have flew in the past two months. In order to
maintain my currency I must fly at least 30 hrs in any 3 months period.
Should I attain the 30 hrs or more in the past two months, I would like cell
B1 to read “0â€. If I still require hours to maintain my currency within the
last month, I would like the actual figure to be displayed in cell B1. Can
anyone help me out with this one?
 
In A1 if you enter the time in the below format
26:
excel will convert that to time format 26:00:00

Then enter the formula in B1
=1.25-A1

If this post helps click Yes
 
If 26: is getting converted to 2:00 then format A1

Select A1. Right click>Format Cells>Custom>Type
[h]:mm

If this post helps click Yes
 
If the entry is in time format should'nt that be

=MAX(1.25-A1,0)

If this post helps click Yes
 
Back
Top