View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default 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.