how to minus the time value
 

How to minus the value of time format value. Ex: Now 12:00 Pm we want to had
that cell to cell 5 mins(like 12.05, 12.10, etc.,)
Please give me solution for this.

how to minus the time value
 

Enter =MOD(A1,1) in the result cell and format it as time!

Regards,
Stefi


€žP Vasanth Kumar€� ezt Ã*rta:

How to minus the value of time format value. Ex: Now 12:00 Pm we want to had
that cell to cell 5 mins(like 12.05, 12.10, etc.,)
Please give me solution for this.

how to minus the time value
 

Please accept my apologies: I do not fully understand your question.
However, if you have a time value in a cell you can add or subtract
five minutes from that value with this value:
=5/(24*60)

.... which is the Excel equivalent of 5 minutes.

Dave O