time - # of minutes = time

  • Thread starter Thread starter AdamB
  • Start date Start date
A

AdamB

Hello,

Anyone know how to subtract minutes from a time and get a time result
in the following example:

A1 = 01:30 (1:30 AM)
A2 = 100 (# of minutes)

?A3 = A1 - A2 = 23:50?

I have expressed A2 as a time but if A3 is a negative time, #### is
displayed. I have also expressed A1 as a date and time and A3 as hh:mm,
but also with no luck.

I need help solving for A3. Any Ideas anybody?

Adam
 
Time is expressed as parts of a day

So use

A1-A2/(60*24)

To convert the minutes to parts of a day

HTH

PC
 
Back
Top