Subtracting minutes from a date

  • Thread starter J. T. SYLVESTER SR.
  • Start date
J

J. T. SYLVESTER SR.

Is there a way to subtract 15000 minutes from todays date and show the
results in date format.
A1 = todays date
b1= #minutes
c1= A1-b1 (the date that many minutes ago)
 
N

Niek Otten

=A1-(B1/(24*60))

Format as Date

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
H

Harald Staff

Sure
=A1-B1/1440
format as date-time. There are 1440 minutes in a day.

HTH. Best wishes Harald
 
Top