how to minus the time value

[Guest]

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.

 

[Guest]

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

Regards,
Stefi


„P Vasanth Kumar†ezt írta:

 

[Dave O]

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