Subtracting minutes from a date

[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)

 

[Niek Otten]

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

Format as Date

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Harald Staff]

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

HTH. Best wishes Harald