View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
robin robin is offline
external usenet poster
 
Posts: 210
Default How to customize =Now()

How do you customize the =Now() so that it is in the format of dd/mm/yy and
hh:mm:ss instead of dd/mm/yyyy and hh:mm (military time). I am trying to have
an elapsed time with the now time minus the start time which is in the form
of mm/dd/yy hh:mm:ss. Will it give the correct elapsed time if it is in the
current format.