View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default subtract minutes from time

You have to divide the minutes by 60 and by 24 in order to subtract
them from a time-formatted value. i.e. if you have 8:15 am in A1 and 15
in B1 try this in C1:

=A1-B1/60/24

and format the cell as time.

Hope this helps.

Pete